Update Fields In Database View?

[mabiem]

I have what I thought was a single issue.

Essentially I have two linked tables (uneditable). They are linked by PersonID and they also have email address in common. For sake of example let's say one table has names of people, and the other table has the address they live at.

I have a user who requires a "datasheet" view of certain columns from each table. No problem, can do that easily in a query.

The issue is that he also wants to have an editable column that would have say "Address Confirmed". Clearly I need another table. If I make a three table query I find no way to edit that new column.

Any idea's pr a new metod would be helpful.

Thanks,

Mike

 

[Estuardo]

G'd evening Mike,
Following your example you don't need another table. you may need another column in your address table. That column might be a Yes/No type. This way you can select the confirmed address.
G'd luck

 

[Pat Hartman]

Welcome aboard

Since your linked tables are not editable, you will need a third table and if you include that table in the join, it will also be uneditable since if ANY part of a query is not updateable, the entire query is not updateable. That means you will need to use DAO or an append/update query to update the table. Your code should be able to insert the record if it isn't there and update it if it is. There is no benefit to attempting to pre-populate the verification table. Records will be appended as needed.