How to show records that do not exists

[azzi2000]

Table1: orderid, cust, date,notes
Table2: orderid, item, qty, price,....
Table1.orderid -> table2.orderid

How can I have a report to list order in table2 that do not exists in table1.

I clikc on the link option and the Not equal sign but it is not working.
Please advice,
Thank you.
Dré

 

[lbass]

Use a left join FROM Table2 TO Table1. Then use a record selection formula like:

isnull({Table1.orderid})

Place your {Table2.orderid} field in the detail section along with any other Table2 fields you wish to display.

-LB

 

[azzi2000]

Thank you.
Dré