Hi everyone
I am having a few difficulties with creating an invoice from a form, When I press the “Create Invoice” button it creates the invoice but sometimes with 2 or more sets of information. When I look back at the table it has in some cases created 2 records for 1 customer. The problem seems to be on the form (or my set up) The form set up is as follows:
Customer details with a tab control containing information from different tables using sub forms. When I add information to the customer and then to one of the sub forms on the tab it creates 2 records with the same customerID.
When I try to create an invoice it appears with one header but a details section for each entry on the tab. 2 of the tabs are from the customer table but all others are from different tables. If I only have info in the 2tabs from the customer table the invoice is perfect.
What I am looking for is to have only one record created when information is entered. My first thought would be to have all the information in one table but that make for one very large table.
Thanks in advance for any help you can give me.
Wingnut74