2 queries work independently, but not together

[ccbarbeau]

Ok, this is driving me mad.

I have 2 calculated fields in FM. Both are related to a work order.

I have 2 queries, one for each field, that give me the expected results when I run them.

However, when I try to make a report that looks like: Work Order    Field 1     Field 2

The data no longer makes sense. I've tried varying the relationship in FM (using different cardinalities) but nothing seems to be giving me the result I need.

Any ideas?

Thanks,

CC

[RobsWalker68]

Hi,

What result are you getting that doesn't make sense and what result do you expect to have?

Thanks

[ccbarbeau]

Hi,

I (well, actually my boss) found what was wrong. My link in FM was OK but I was missing one.

All is well now.

Thanks!

CC

[PRIT AMRIT]

Lucky u.. .got a technically sound BOSS around  ;D

[Arsenal]

Lucky u.. .got a technically sound BOSS around  ;D

Not always the best thing, since BS'ing becomes harder  :P