Omitting Records with BLANKS in a Field 1

[RADAZ]

I have two tables. I want a report of all records in one table that have no corresponding records in another table.

Is that done by JOINS?

My "Profile" table contains all of our customers. My "Subset" table contains all records for our customers. If a profile record exists, but no subset record exists, I want a list of those so I can delete the profile records.

Thanks so much! I did not find this in my searches.

 

[lbass]

Use a left join FROM the profile table TO the subset table. Make sure you add no selection criteria on the subset fields. Then write a record selection formula like this:

isnull({subset.customerID})

This will return only those customers in the profile table who do not appear in the subset table.

-LB