linking multiple tables - duplicate record problem

[mollie]

Hi -

I'm trying to create a report that uses an item file an invoice file and an open order file. I link from the item file to invoice file and from item file to open order file. I have 2 detail lines (one invoice/ one for orders). I'm getting tripped up because it doesn't skip if there is no record for a specific item. So, a line might show up for an open order, but in reality it's not existent. I've tried left and right joins, but no luck. Any tips would be appreciated.

Also - any ideas on how to have current and history files on the same report? Is it the same logic? (meaning I would want a current invoice and a history invoice file to be read on same report).

Thanks a lot!

 

[dgillz]

Well, just a guess here, but if you have the item number from the item file, every item will show up regardless if it is in the open order file or not, even if the open order file is blank.

Use the Item # from the Open Order line file instead. An alternative is to setup a record selection formula:

Not Isnull({OpenOrders.ItemNumber})

Which would exclude records with no open orders. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office