Newbie question: how do I make a form or view where I see one row in the ‘master’ table, e.g. Order, and I see all the associated records in the ‘detail’ table, e.g. Order Line?
I found this feature request from a couple of years ago but I’m hoping Airtable now has some way to do this fundamental way of looking at data?
In my particular case I’d like users to be able to browse through records in my ‘master’ table, seeing a handful of fields in the selected master record, and see a tabular display of the associated records in the detail table. I’ll have a couple of buttons (or similar) allowing them to perform actions on the master record they’re currently viewing (e.g. Approve, Reject, triggering a script block to run for that record).