Hi, I was wondering if the experts here can help me with a problem I am having. I have 2 tables, one with order numbers, order dates, custumers, etc. It is linked to another table by order number that contains the specifics of that order, i.e. the specific item, price, etc. There is one field in the detailed table I would like to check, and if it passes then I want all items for a order number to be printed.
For example, the first table would have:
Order# Cust# Date
12345 6789 1/1/02
...
The second table would have
Order# Item# Quantity Price CheckField
12345 1 1000 $1 No
12345 2 2 $100 Yes
...
So for every order# I would go through each item and look at the CheckField to see if it is true for any item of that particular order#, if it is I want to print out all the items of the order# whether it was true or not.
I hope I am making sense. Any help on this matter would be appreciated. I think this deals with suppressing sections rather than record selection formulas, since the selection depends on other records, though I could be wrong. Thanks in advance.
For example, the first table would have:
Order# Cust# Date
12345 6789 1/1/02
...
The second table would have
Order# Item# Quantity Price CheckField
12345 1 1000 $1 No
12345 2 2 $100 Yes
...
So for every order# I would go through each item and look at the CheckField to see if it is true for any item of that particular order#, if it is I want to print out all the items of the order# whether it was true or not.
I hope I am making sense. Any help on this matter would be appreciated. I think this deals with suppressing sections rather than record selection formulas, since the selection depends on other records, though I could be wrong. Thanks in advance.