How to auto update Tables from another Table

[Jignesh]

I want to auto update data information from another table. Below is my table
set ups.


I want to link two tables so it updates automatically when one table field
is updated another table field is also auto update.
There is data into table call “Equipment Information†and I’ve link one
field from that table which is nameâ€EquipmentIDNo†to “Cost†table via Lookup
setting in cost table. Because I would like to take the Equipment Id No from
“Equipment Information†table and put into “cost†table so I can enter any
cost related to that Equipment. And “EquipmentIDNo†is way to figure out
particular equipment. So now everytime I enter new information into
“Equipment Information†table the “Cost†table does not get auto update,
therefore, everytime I have to open cost table and pick from Drop down menu
and add the “EquipmentIDNo†into cost table. So my question is how can I set
up this database so it picks up any information that I enter into
“EquipmentIDNo.†Field under “equipment information†table and sends to “Cost
table†?

I hope I’ve written my problem or explained it correctly. Any help would be
greatly appreciated.

Thanks,
Jignesh

 

[John W. Vinson]

I want to auto update data information from another table. Below is my table
set ups.


I want to link two tables so it updates automatically when one table field
is updated another table field is also auto update.

No. You don't.

Storing the same information redundantly in two different tables is neither
necessary nor good design.

There is data into table call “Equipment Information” and I’ve link one
field from that table which is name”EquipmentIDNo” to “Cost” table via Lookup
setting in cost table.

The "Lookup" field type is a widely reviled misfeature in Access. See
http://www.mvps.org/access/lookupfields.htm for a critique.

Because I would like to take the Equipment Id No from
“Equipment Information” table and put into “cost” table so I can enter any
cost related to that Equipment. And “EquipmentIDNo” is way to figure out
particular equipment. So now everytime I enter new information into
“Equipment Information” table the “Cost” table does not get auto update,
therefore, everytime I have to open cost table and pick from Drop down menu
and add the “EquipmentIDNo” into cost table. So my question is how can I set
up this database so it picks up any information that I enter into
“EquipmentIDNo.” Field under “equipment information” table and sends to “Cost
table” ?

If every record in the Equipment Information table has one and only one record
in the Cost table... just put the cost field into the Equipment table! What's
the point in having two tables? What's the structure of the Cost table?