how do i link two tables information together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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?
Click to expand...

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]
 
Back
Top