Secondary lookup table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to pick from a lookup table to insert information into a column.
Based on the selection in the first column, I would like to have different
lists available for a second column. For example, column A would have a
lookup table with "flow switch" and "level switch" as the available picks.
When filling out Column B, if "flow switch" is picked for column A, a lookup
table with "target type" and "pressure type" would be available. But if
"level switch" is picked for column A, "float type" and "conductivity type"
would be available. Thanks.
 
The Northwinds sample application supplied with Access provides an
example.

HTH
 
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

lookup table based on two criteria 3
newbie question: lookup always returns ID, not combo box value 4
Preserving input mask when using field in lookup for a second tabl 1
Fill in multiple fields with one lookup 0
Excel vba code to match duplicates 4
Lookup in gridview 6
Multicolumn lookup in one table from another. 7
Windows XP VBA coding assistance 1

Back
Top