You can make a field in table A called [Order Exists?] as a formula checkbox with a formula of
true
Then make a relationships where One table A has Many Table B's and for the reference field on the right use a formula field with the value of [order#] as the formula. ie a mirror of the order#.
Then in that relationship look up the field of [Order Exists?]
Then are you have to do is make a report filtered by where [Order Exists?] is unchecked.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
