Multiple sources for a combo box? (1 Viewer)

[mlopes1]

Wondering if there is an easy way to do this:

I have a combo box that is populated by a TableA with Product #'s. I also have another TableB that holds "miscellaneous items" and their Product #'s. I would like a combo box to show both sets of records in its list but I don't want to combine the tables if possible... can this be done?

Thanks as always,

Marco

 

[jeremie_ingram]

Base it off of a query that pulls the data from both tables. This way the tbls hold thier structure and you get everything you need.

 

[mlopes1]

I'm unfamiliar with how to do this?

TableA, field called Item # and TableB field called Stock #. Query to pull both into one field so the form's combo box can be populated by whole list. I think I get the concept (thank you) but don't really know how to go about this. Currently have my query open in Design view and both tables showing in top window... that's about it!

Marco

 

[mlopes1]

Nevermind... I was able to figure this out. It was alot simpler to do the join query than I had thought. Thanks for the idea!