I'm creating a billing database and currently, I'm pulling records from the sales table using the current CustomerID, and two textboxes to give a date range as the criteria for the query. From here, I want to be able to create a record in the Invoices table with the CustomerID, StartDate, and EndDate from the form. The Invoices table is designed as follows:
- tblInvoices
-
InvoiceID PK
-
CustomerID
-
BeginDate
-
EndDate
At first I thought I would use an Append Query, but it looks like the information has to be from a datasource such as another table or SQL database. I could use an Update Query if I could have it update the new record since the InvoiceID is an AutoNumber field. What is the best way do to this?