Hi all, I have a multi-table form that is used for invoicing. There is a header section that addresses one table (invoices) and a region that addresses another (invoicedtl).
The invoice is established by inserting an integer key, invoice #, company id, and an a/r account# into the header and the same integer key into the detail table before editing. An eep (on a button) is used to choose a customer and it updates "invoice" with the customer ID and another code. This then skips to a date column to be filled in by the user. This all works fine. But the moment you click into the detail section of the form, the customer id and code updated by the eep are set to null. And, interestingly, the date filled in by the user and all the data inserted prior to the edit are left alone. I watched this unfold by running the app in one window and doing selects against the invoice table in another as I used the form. I can think of a number of work-a-rounds, but I'd rather correct something I'm doing wrong or change a setting, or .... TIA, Ben Petersen
