Combo Boxes

[mlbranson]

Hello -

I was wondering if someone could help me work through this problem.
have prepared a database for a sugar refinery whereby I am outlinin
what screens are located within each sifting machine. I have a for
"sections" which defines the sifter, and a subform "screens" containin
the screen details for each "section."

I am trying to find a way to have my combo box "locations" not onl
populate my table, but also fill in the "locationID" field in th
subform, so that I can keep track of what screens go to which plan
location.

In other words, I would like my combo box to fill in two tables at th
same time.

Thanks in advance for your help