Skip to main content

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?

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.

Reply


Terms & Conditions