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

  • Thread starter Thread starter Ben
  • Start date Start date
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?
 
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.
 
Back
Top