Populate Combobox with data from 3 tables

[alaska_av8r]

Is it possible to populate a single combobox with data from 3 different tables.

I have a table called observations (for observing deer), in that table is a field called Location, I have 3 other tables that list possible locations t_foodplots, t_stands and t_section.

I would like to have a combobox called location on my observations form that will allow me to select the proper location from one of those 3 tables, the choices would be something like this...

Section 1
Section 2
Section 3
Stand 1
Stand 2
Stand 3
Foodplot 1
Foodplot 2
Foodplot 3 etc....

the chosen value would be stored in the t_observations "location" field.

thanks in advance for any help....

 

[bob fitz]

Perhaps a better way would be to create an Option Group control or another combo box control on the form so that the user can select which of the three tables the choice is to be made from and then set the Row Source property and the Control Source property of the second combo after the selection is made in the first combo box.