combo box showing a field or a table list

[ace]

I have a real estate application and followings are my tables;

tblResourceType
1 Seller
2 Seller Agent
3 Office Assistant
4 Virtual Assistant
5 Buyer
5 Buyer Agent

tblTransaction (this table contains all transaction information)
ID-Transaction
ID-Seller
ID-Buyer
ID-SellerAgent
ID-BuyerAgent

tblSeller
ID-Seller

tblBuyer
ID-Buyer

tblSellerAgent
ID-SellerAgent

tblBuyerAgent
ID-BuyerAgent

tblAssistant (contains Virtual Assistant, Office Assistant, etc.)
ID-Assistant

In a form, I select the Resource Type using a combo box and using the table
tblRsourceType. Correspondinly, I need to pull and display the name of the
person for a particular ID-Transaction or a list of person to select from. In
cases like buyer/seller/buyeragent/selleragent the tblTansaction table which
contains the foreign key for those four resource types. However, if Office
Assistant or Virtual Assistant is selected, I may have a list of Office
Assistant or list of Virtual Assistant to select from. So, when those are
selected I need to show the list of assistants to a user to select one from.

I appreciate any help in coding this.

Thanks,
AC

 

[Arvin Meyer MVP]

Have a look at the list boxes which control the second choice in this sample
database:

http://www.accessmvp.com/Arvin/Combo.zip

 

[ace]

Arvin,
I would appreciate if you can be little more helpful!

I have opened the sample database. The form looks blank in form view. Is
this normal? I can see it in design view. However, I am not experienced and
looking at the form does not help me much! I do not see the tables, queries,
relationships, etc. So, it is difficult for me to put it together by just
looking at the form!

It would be great if you can reply to my question based on my settings
outlined in my initial question.

Thanks,
AC Erdal

 

[Arvin Meyer MVP]

So first make a selection from the first listbox. That fills the second
listbox. When you make a selection in the second listbox, it fills the form.

 

[ace]

I do not think you read my question and comment!!!