I have decades of consulting experience using RBase and Access. I’m used to creating forms that display the One-to-Many relationship between two tables. For example, one form could display an Order in the upper part of the form, and then in a subform each Product for that Order could be displayed in rows, with Price, Quantity, and Extension for each Product, and totals at the bottom of the subform. The Order and the Products would be related by an Order ID field.
I’m new to Airtable. I can’t see any way to do what I describe above in Airtable. Can anyone direct me to a tutorial, or tell me what I am missing? Any help would be appreciated.