Update tables based on "lookup" changes

[Guest]

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

 

[John Vinson]

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

I load the component table.

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

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.

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?

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

John W. Vinson[MVP]

 

[Guest]

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