Form, Subform, and Combo Box (1 Viewer)

[lwallis]

Can anyone tell me if what I want to do is possible?
I have attached a portion of my database. if you go into the form called frmtest, select a branch from the very top drop down, select a detail and click the Edit button.
I can't figure out how to have the information populate all the fields for editing. The Cost and Quantity fields work but my combo box fields don't properly work.
The top combo box populates but when the record is updated it doesn't save the id. The second combo box doesn't even put the data in the data box.
The main table where IDs and fields are is the BRANCH_EXP table, it's a linking table which links tables with many to many realationships.

WARNING... I am not a programmer so I'm sure this is ugly, I've been trudging through by looking at examples on the Internet... :banghead:

Is this even possible?

Thank you for your suggestions
Lynda

 

[JHB]

Try it now, (database attached)!

 

[lwallis]

WOW! Thank you so much JHB. I works just how I need it to.

 

[JHB]

You're welcome, luck with your project.