Field value from one of several tables and auto-populate

[Dregoth]

Hi There,

I have a problem I can't figure out....

I've created a database with several tables with each table containing it's own set of unique ID's which are unique in the DB. (new tables will be added every few months)

I've also created a table combining the unique ID from each table. Now I would like to add a field to this table which will lookup a field value linked to the unique ID, but this field value can be in any of the other tables.

Or more specific:

I'd like to add a name field to table(multiverseID master) which will lookup the multiverseID in the other tables and give the corresponding name value from the table which contains the relevant identifier.

So.... help? Thanks -)

[Vaughan]

new tables will be added every few months

Ok stop right there.

There should be no reason to be adding new tables every few months. From the pic it looks as though each of the tables are duplicates, and they are storing variations of similar things.

Put all these into one table with a Type field to differentiate them.