Can I set a field to have a dropdown menu based off other tables

B

Ben

I want to set a couple of fields in one table to be drop down menus of data
in another table. Is there a way to do this?
 
K

Klatuu

Don't do that at the table level. Lookup fields are more trouble than they
are worth.

The typical way to do that is use a combo box on a form and a query that
will return the fields you want. Then you can bind the combo to field in the
form's record source.
 
Top