Missing Record Details

[Guest]

In my database, users input records on a form and subsequent sub-form. The
form has all customer-specific data and the sub-form has the record details
of that transaction.

For various reasons, a user might start a record but not complete the
sub-form. This throws off my reports. Unfortunately, the main data is
stored in the main table and record details are stored in another table, tied
together by the record ID.

If the sub-form is blank, the record ID is not even listed in the sub-table.
Is there a way to query my records to find any record that does not have
record details? Thanks in advance.

 

[Guest]

Hi Everyone,

Please ignore this question as I was able to figure it out. I only had to
query the record ID from the main table to look for blank or null values on
the sub-form.

Thanks,
Jim