selecting in table using 2 combos refering

[plynius schull]

Hi,
prity new to access...
I have 3 tables,
T1=ID1, name1
T2=ID2, name2
T3=ID3, reference_to_ID 1,reference_to_ ID2, ...
I want the user to select 1 of table 3, by selecting the names out of T1 and T2. So 2 combo-boxes, 1 with names1 and 1 with names2. How can I solve this easy way?
I also want to only show up the names of T2 which have corresponding reference with the selected name1 in combobox1 in T3.
fast example:
T1=11,a; 12,b; 13,c - I made IDs from 11 on
T2=21,p; 22,q; 23,r - IDs from 21 on
T3=31,11,21; 32,11,23; 33,13,22,... -IDs from 31 on
so if selected combobox1 'a' only show 'p' and 'r' in combobox2

The choosen record in T3 will be used for other things of course...

[sierra7]

Hi
This sounds like school homework Mr.Schull!

It's called cascade filtering. Look it up.

5/10 for trying
S7

[plynius schull]

Hi Sierra, I figered it out with the cascade-word. I'm 30 years old so no school job. Thx anyway.

[sierra7]

Sorry if I was rude!
It looked like an exam question.

There are some good 'Insight' articles on this site which deal with such topics but I can't figure-out the menus to find them.
S7