I'm an Access newbie.
I have two tables that have a one-to-one relationship. What I want to do is delete all records from Table 2 where the first field is present in Table 1.
So in Table 1, I have an employee number listed. I want to delete the entire record in Table 2 with the corresponding employee number. When I try, I get the message "The operation must be an updatable query". Any help?
I have two tables that have a one-to-one relationship. What I want to do is delete all records from Table 2 where the first field is present in Table 1.
So in Table 1, I have an employee number listed. I want to delete the entire record in Table 2 with the corresponding employee number. When I try, I get the message "The operation must be an updatable query". Any help?