I want to test if a field is empty for all related records. Is this possible? And, if it is, can you please explain how to do it?
For example, I have a table with customer information, which is linked to a "purchases" table by a number that is unique to each customer. I want to see if a specific field in the "purchases" table is empty for all of the records for each specific customer. Basically, I want a field on the customer information table that says either "No" (all records are empty for that person and specified field) or "Yes" (all records are not empty for that person and specified field).