using 1 form to update 3 tables

[shanewa]

I am trying to use one form to update 3 tables.
I have a form with 3 text fields and 3 combo boxes (the combo boxes are based on lookup queries).

1. is a text box that's uderlying source needs to be a field from another table (how is this done?) control
source?

2. source is table which form is based on

3. is a combo box based on a query which is not the underlying source for the form

4. source is table which form is based on

5. is a combo box based on a query which is not the underlying source for the form

6. is a combo box based on a query which is not the underlying source for the form

The last two combo boxes need to be exlusive, either an owner or a region. they do not reside in the same
table. They will be put into the table that the form is based on. # 5 which is not based on the underlying
table that the form is based on but does however share the unique id with the table that the form is based
on. both are text characters.

any help would be apprecitated. sorry if it is hard to follow.