Update tables based on "lookup" changes

D

DLM

Have a "product table" and a "component table"

I load the component table.

A field in the product table is "component" - lookup.

Changes made to "component" are not showing up in the product table.

How can I make changes to components that are automatically seen in the
product table?

Thanks
 
J

John Vinson

Have a "product table" and a "component table"

I load the component table.

A field in the product table is "component" - lookup.
Click to expand...

Lookup fields are of VERY limited utility, and have many other
problems. See http://www.mvps.org/access/lookupfields.htm for a
critique.

The lookup *technique* on the other hand is univeral: just do it on a
Form, using a Combo Box control on the Form. It's very easy to use the
toolbox wizard to create a combo; it is not necessary to have a lookup
field in your table to do so.
Changes made to "component" are not showing up in the product table.
Click to expand...

Sounds like the combo box needs to be requeried (easy to do on a form,
impossible in a table). Does the new information appear if you close
and open the table, or if you press F9 to requery?
How can I make changes to components that are automatically seen in the
product table?
Click to expand...

Use a combo box on a Form, and requery it after updating the component
table.

John W. Vinson[MVP]
 
M

Marcel

you could try enforcing the relationship for inserts and updates between the
two tables
 
Top