I have 3 tables: Sales, items, customers. Each has an autonumber key field. The Sales table includes a foreign field for items and for customers. The links work correctly.
To find any sales records without matching records in the items table, I ran the unmatched query wizard and got a query named “Sales without matching items” which has what looks like an empty or new record, signifying there are no sales without valid items. Then I ran the unmatched query wizard to find out if I had Sales without matching customers. “Sales without matching customers” has no empty record – it is gray below the field names and navigation buttons are “grayed out”.
What is the significance of the difference?
Thanks.
Sanora