In Access 2007 we have a form with a subform that we use to create invoices. The main form contains the company information such as point of contact, address, phone, etc.. The subform has the items that were purchased. Our question is how can we save the invoice in case we have to refer to it at a later date. The way it is set up now the main form references the company ID and when we query by that we bring up everything that company has ordered in the past. We just want to reference a specific invoice.
We may have set this up wrong from the beginning. I hope not. Any help will be appreciated.