I have related tables: Invoices and InvoiceItems. I have created a 1:M link between them. How do I add an invoice and then add the items? I have looked at the lesson for related tables, but it seems to deal only with editing, not adding. I know how to create a button and use the show dialog action to open a form, but how do I get the invoiceID of the record I just created? Is there an automatic way to do this? Help! thanks.