Can a combo box display results from two unrelated tables

[Eddy Sincere]

Here's another short question - Can a combo box display information from two unrelated tables, but that have the same design?

I have two item number tables and they are both designed the exact same way, i.e. Column 1 = Item Number; Column 2 = Description. I want the combo box to pull from both tables and "add" the second table to the bottom of the first table.

[June7]

Use a UNION query.

Why do you have two identical tables?

[Eddy Sincere]

Thanks.

I'm building a specification db and one number "rolls up" into the other.

Level one components are used in level two blends
Level two blends are used in level three capsules.

In the first scenario level one is the child and level two is the parent, while in the second scenario level two is the child and level three is the parent. Seems simple enough.

When I put all the item numbers into the same table I can't enforce referential integrity because the table which links the parent to the child would have two columns with the same name (they have the same relationship to the same table).

I'm not sure if I'm making sense. If i'm not just let me know and I'll be happy to post the DB. If there's a better way to do it I'd love to.

[June7]

By 'enforce referential integrity' you mean in the Relationship builder? Many developers don't bother with that and use forms and code to manage data integrity.

But I've never had to deal with a database like you describe.

Did the UNION give you what you want?

[Eddy Sincere]

Correct, I use the relationship builder to keep the database clean. I'm definitely not a developer so coding to manage the data is a bit beyond me.

Yes, the Union worked perfectly. Thanks again, problem solved.

FYI - I went to the link below and followed the instructions. Very helpful.

https://support.office.com/en-us/art...rs=en-US&ad=US

[June7]

What that does not show is that you can construct fields in the UNION with expressions.

So if you want a field to show which table the record came from, something like:

SELECT "Table1" AS Source ...
UN ION SELECT "Table2" ...