Lookup restrictions

[lputnam]

I want to create a table with drop down (look Up?) field that restricts the
next drop down box in the next field. I want to select a model in one field.
Based on that selection, a list of options pertinent only to that model are
the only ones to filter(?) in the drop down box in the next field.

What is this called? I have 3 access books and cannot find it.

 

[KARL DEWEY]

Do not do this in a table but in a form.
Search on 'Cascading Combos'.

 

[Gina Whipp]

And here's a sample... http://www.fontstuff.com/access/acctut10.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[lputnam]

--
Lou Putnam

Do not do this in a table but in a form.
Search on 'Cascading Combos'.

Thank you