how do i link two tables information together

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fredo - 11 Apr 2005 18:48 GMT

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?

Reply to this Message

Pat Hartman - 11 Apr 2005 19:00 GMT

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?

Reply to this Message

John Vinson - 11 Apr 2005 23:24 GMT

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

Reply to this Message