Connecting 2 Combo Boxes Problem

[aamer]

Help Needed.

I have a combo box "Combo28" on Purchase form and I have a Combo box "Combo464" on Admin Purchase subform
I want if I select "Combo28" with "Dimple Cottage Works" It should show me the Price list of Dimpi in "Combo464" & If "XYZ Exports Ltd" It should show me the Price list of coke
How can I do this.

For better understanding I have attached Sample Database.



Combo Sample DB.zip

[June7]

I see a lot of problems with data structure.

You have an autonumber ID field in Company table yet you have the company name field set as primary key and save the company name as foreign key in Purchases.

What is Purchases field called [Purchased From Company] for?

No reason to save both company ID and company name in Purchases. Also no reason to have both fields in the Master/Child links properties. Only the primary/foreign key fields should be used.

I don't see anyway to do what you want. I don't see any relationship between company and price list. There is no way to know which PriceList records go with which companies.

Looks like each purchase is limited to a single product. Is that what you want?



BTW, misspelled "Entery" should be Entry in the popup message. Catagory should be Category.

Also advise no spaces or special characters/punctuation (underscore is exception) in object names. Better would be BillNum or Bill_Num instead of Bill #.