I feel like this question has been asked by multiple users, but I still find myself confused. Here’s what I’m trying to accomplish:
A content calendar where the first table is sort of an “overview” with status, series, episode number, etc. linked to multiple other tables which include different types of content. I say multiple tables because different types of content have different fields. For example, a blog post in classic list format is going to have an intro, list items, and conclusion. Whereas a detailed case study blog post will have vastly different fields.
So - I have multiple different tables, each containing a unique set of fields for that type of content. I would like to be able to pick records from any of those tables for my linked record on the overview table (which is the table where I order episodes and update the status of content).