By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

selecting in table using 2 combos refering

P: 5
prity new to access...
I have 3 tables,
T1=ID1, name1
T2=ID2, name2
T3=ID3, reference_to_ID1,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...
Jan 11 '12 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 446
This sounds like school homework Mr.Schull!

It's called cascade filtering. Look it up.

5/10 for trying
Jan 12 '12 #2

P: 5
Hi Sierra, I figered it out with the cascade-word. I'm 30 years old so no school job. Thx anyway.
Jan 23 '12 #3

Expert 100+
P: 446
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.
Jan 23 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.