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
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?