Create an index of records from multiple tables?

Topic Labels: Base design
340 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

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?

0 Replies 0