Create an index of records from multiple tables?

Topic Labels: Base design
1042 1
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?

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

I have the same question as we build out a digital asset management base. Assets will be sourced from various bases for example individual pics and company logos from our CRM, event pics from our events base, articles from our eNews base, etc.