combo boxes in tables

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?

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).

--
Duane Hookom
MS Access MVP


"closkey" wrote in message
...
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?