I inherited a terrible Access database and I'm having to clean it up. I need to establish a relationship between the 2 tables. When I tried that the error message was that the ind table violated the rule for referential integrity. I am trying to enforce updates and deletes and evidently there are records in the ind table that have no record in the fam table. I need to run a query that tells me what records in the ind table have no corresponding records in the fam table. The field in the fam table is ID (auto number) and the field in the ind table is fam_id. maybe I'm brain dead from dealing with this POS but I can;t think of how to structure the query. Any help?