May 30, 2021
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:
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
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?
Aug 09, 2023
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.