Create an index of records from multiple tables?

Hey, can anybody think of a way to create a table that consists of a listing of all the records in several other tables in an index format. Something like this:

Primary Field Value | Table Name

Bob | First Names
Goldthwait | Last Names
Comedian | Occupations

I want to produce a single table like the one above, dynamically and continuously from live data, from a base that contains the following tables:

TABLE: First Names
RECORDS: 1 Bob

TABLE: Last Names
RECORDS: 1 Goldthwait

TABLE: Occupations
RECORDS: 1 Comedian

This is just hypothetical data.

I know I could this by exporting to a spreadsheet and reimporting but I want it to be automated and real-time. Any ideas?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.