Using three comboboxes to access/update data in a table?

[TKTheKid]

Hi all,

Please see the attached database file and look at formWarehouseData.

I have three comboboxes. When the user selects a ticket, the source for the location combobox changes, then when the user selects a location, the source for the article combobox changes.

My question is, how do I make it so that when a user selects a ticket, location and article from all three comboboxes, the correct quantity from tableWarehouseData appears in the fourth box there?

Any help is much appreciated.

Thank you!

Tony

 

[TKTheKid]

I see my database has 8 views. Did anyone have an idea?

Thanks!