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