Problem with Updateable Query

[Will04]

Hi everyone,

I have four tables (all linked by a unique identifier) which I populate via data entry forms. I would like to give the user an option of making changes to the data by entering the unique identifier and displaying the specific record (from all four tables).

Is there any way to write an updateable query to accomplish this task?

I started with a query of two tables and this was updateable.

I then added a third table and now it don't work.

Here's the SQL statement
-----------------------------------------------------------------
SELECT tblPerson.*, tblPermaddr.*, tblTempaddr.*
FROM (tblPerson INNER JOIN tblPermaddr ON tblPerson.FILENO = tblPermaddr.FILENO) INNER JOIN tblTempaddr ON tblPerson.FILENO = tblTempaddr.FILENO
WHERE (((tblPerson.FILENO)=[enter fileno]));
-----------------------------------------------------------------

Any suggestions??


Many thanks in advance.

Will

 

[kidrobot]

tblPerson INNER JOIN tblPermaddr ... that doesn't seem right?

If you want to make an update query you can change it to any update query instead of a SELECT query. The SQL would change to UPDATE TO blah blah