I'm having a heck of a time with nested record selection formulas.
I've got on 3 linked tables - Buyers =* Orders *= Sellers
I need to display all orders which had XYZ as a buyer or seller, and only info from the -1 version of the buyer or seller table. The problem I'm having is: how to select the -1 version without excluding orders which only have a buyer or seller (but not both). Here is my formula:
({Orders.BuyerName}= "XYZ" or {Orders.SellerName}= "XYZ" and
({Buyers.version}= -1 or IsNull({Buyters.Version}) and
({Sellers.version}= -1 or IsNull({Sellers.Version})
I know the tables are linked together correctly because if I eliminate the last two rows, it returns all possible combinations (inlcuding only one buyer or seller)
Thanks in advance for any help.
I've got on 3 linked tables - Buyers =* Orders *= Sellers
I need to display all orders which had XYZ as a buyer or seller, and only info from the -1 version of the buyer or seller table. The problem I'm having is: how to select the -1 version without excluding orders which only have a buyer or seller (but not both). Here is my formula:
({Orders.BuyerName}= "XYZ" or {Orders.SellerName}= "XYZ" and
({Buyers.version}= -1 or IsNull({Buyters.Version}) and
({Sellers.version}= -1 or IsNull({Sellers.Version})
I know the tables are linked together correctly because if I eliminate the last two rows, it returns all possible combinations (inlcuding only one buyer or seller)
Thanks in advance for any help.