Updating two tables from one form.

  • Thread starter Thread starter BBB
  • Start date Start date
B

BBB

I am creating a small database to track component repair
info and inventory. How can I update location and
equipment status in the two related tables from one form?
Thanks in advanced, BBB
 
Assuming you have some common indentifying field between the two tables,
create a query with a join on the common field. Base the form on that
query.

This brings up the question of normalisation though. If you have a 1:1
relation between the two tables, its most likely they should be combined
into one.

If you have a 1:many relation, then you will need a form - subform
arrangement to view the data from both tables.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
BBB said:
I am creating a small database to track component repair
info and inventory. How can I update location and
equipment status in the two related tables from one form?
Thanks in advanced, BBB
Click to expand...
By basing the form on a query that expresses this relationship.
If many to one the many side might be better off in a sub form.
 
Back
Top