Building my first base and am a bit confused on the best structure. I oversee several legal cases, and one of the things that must be tracked are court transcripts. I have a table with the following headings: Hearings, Court Documents, Evidence, Transcripts, People, Notes, Expenses.
Obtaining the transcripts is a process that involves filing a form, contact data for the court reporter, paying the reporter their fee, noting the date we actually obtain the transcript. I also need to document all the attempts made to contact the court to get approval for the transcript to be prepared: date/time, person contacted, their contact info, result.
It seems as though the transcripts should have their own table. Is there some way the Transcript info could be entered once and appear in both the Transcript Table and the Main Table? In the main table, I would only want to display whether we have the table or not (process status), but while in the Main table, I would want to expand to see the detail of the transcript acquisition process. How to accomplish this please?
Many thanks in advance for your assistance to this absolute Airtable newbie.