I have a database with 2 tables.
The first one is the list of invoices (Airtable - Grid view), and the second one is for all the invoice lines (https://airtable.com/shr7SIHWwTSG0oM9H).
I want to create a form to add products in the second table. But first I need to create an entry in the first table (the invoice number) before I can add the items (table 2).
I want to make the process simple, and not have 2 forms to fill in. Do you see a solution? The only solution I have found is to make a first form to add an invoice, and in the reply message it links to adding the rows (Form) but it is not very user friendly, and people can get confused.
I don’t know if I have made myself clear,
Thanks in advance to the community