combo boxes in tables

C

closkey

In a FORM, I can have combo box 1 limit the results in combo box 2, but how
can I do this in a TABLE? For example, I have three tables: "Terminal_Info",
"Die_Info", "Terminal_Setup". In "Terminal_Setup", I have fields:
"ParentPart", "Terminal", "Die". The "Terminal" field has a "row source"
looking at "Terminal_Info". Once the user has selected a "Terminal", I want
the "Die" combo box to only show those records that are related to that
"Terminal". I have tried using the SELECT function, but with no luck. Any
ideas?
 
D

Duane Hookom

The accepted professional solution is to never use lookup fields in table
design. Apparently you know how to accomplish the same with forms (where all
data interaction should take place).
 

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

Combo box 0
Combo or list box 0
Combo or list box 0
Link a text box based on drop down box with four options MS Word 365 0
How to have two tables on same line? 1
Treating multiple paragraphs as one 2
Text Field is Now Combo Box 2
Auto populate field in table 3

Top