Query updatable when tables local, but not when linked

[paron]

I have structured two tables in a one-to-one relationship. One has publicly-accessible information about our personnel like Office Extension or Supervisor Name, the other has Human-resources-only information like Date of Birth and Salary.

I am making a front end for HR to use in maintaining the data. I want the record from both tables to be treated as one for them, and so set up a simple equijoin on a common EmployeeID field. (In one table it's an AutoNumber, and in the other, a long integer type.)

Works like a champ (Add, delete, edit)when run from the db where the tables are local, is not updatable when run from the front end.

What gives, please?

 

[paron]

P.S. I am also posting this in the Access Queries and Jet SQL forum JIC it really belongs there.

Ron

 

[paron]

Partial answer to my own question -- Access made a duplicate join on the linked tables. It's really only visible in the SQL view of the query.

Why it does that, I don't know, but the query's working OK now that I eliminated the bogus join.

Ron