Yes the line items table is displayed as a sub form on the main form.
Which i want to auto populate the line items based on the product field selected on the main form.
Thanks everyone.
The area that I am struggling with is getting the invoice line items to automatically populate.
Invoice header contains a Product Code:
I then want to populate the invoice line item table automatically ready to verification.
Eg,
Product A is selected on the Invoice Header...
Hi All,
I am hoping that you can help me. I've been using access for years but after a long break I'm having trouble breaking back into it.
What I'm trying to achieve is create a database whereby an 'Invoice' document will be produced but also the information is saved in an invoice table...