Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Create an index of records from multiple tables?

Topic Labels: Base design
320 0
Showing results for 
Search instead for 
Did you mean: 

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