deleting records that have no relation

[ejh]

I have two tables, one for jobs and one for clients. I have a one-to-many relationship, so one client can have many jobs. Due to a problem with data entry, I have some client records that have no job associated with them. I need to delete these records. I am very new to access and this isn't supposed to be my job, so I don't really know how to do this.

How do I do this?

[apr pillai]

1. Create a new Yes/No Field with the fieldname FLAG in the Jobs Table.
2. Create an Update Query like the sample SQL given below by linking them both on the Key fields:

UPDATE Clients INNER JOIN Jobs ON Clients.ID = Jobs.IDX SET Jobs.FLAG = True;

3. Run the Update Query to mark the FLAG field for matching records of both tables.
4. This action will leave the records in the Jobs table which have no corresponding Clients records.
5. Create a DELETE Query on Jobs Table to select and delete the unmarked records.

DELETE Jobs.*, Jobs.FLAG
FROM Jobs
WHERE (((Jobs.FLAG)=False));