Profile table and data table

[Red Stapler]

hi,

hoping someone can assist me in this project, as I am new to InfoPath.

I created a form with an Access db connection. There are two tables,
one is a profile table and the other collects information from the
InfoPath form. The form asks users for div, subdiv, and units.

tProfile tData
div div
subdiv units
city subdiv
state
country


Ideally, I'd like to have the subdiv field as a drop down list, tied to
the tProfile table, which would then populate the div field
automatically. Subsequently, the user would then only have to input in
the # of units and all three fields (div, subdiv, units) would update
to the tData table.

any help would be appreciated.

Thanks.

Vu