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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dropdown to populate 2 fields 1
C# Skype silent connection 0
Creating a Form from a Table 2003 3
Filling drop list 5
Restrict Choice in Shared WB (drop down alternative)? 0
Update certain record fields in one table if data exists in anothe 1
Autoadd data to a table that is used as a value list for dropdown 4
How to Populate Data from a table to another 0

Back
Top