how do i link two tables information together

[Fredo]

hello i have a database, well i have a form that writes to a specific middle
table which i am trying to get this table to update the original table how do
i do this?

 

[Pat Hartman]

There is no automatic way to make one table populate another. Normalization
rules would prohibit that. So, if you want to duplicate data, you're on
your own. You will need to use ADO/DAO or an update query.

 

[John Vinson]

hello i have a database, well i have a form that writes to a specific middle
table which i am trying to get this table to update the original table how do
i do this?

Well... you should never need to do this. In a properly normalized
database a value in one table (your "original table") depends only
upon the primary key of that table. You're asking it to depend on the
primary key of some OTHER table (your "middle table").

Please give a specific example. It probably is not necessary to store
this value in your original table at all.

John W. Vinson[MVP]