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?
