You can download an invoice template for Access from Microsoft if that would be helpful: CLICK HERE
I have a database designed. I want to created a subform based on a table with a lookup. The lookup pulls the product name from another table, which also contains the price. I want the correct unit price to appear on the form for the product selected.
Got it. I'll open the question for other experts to answer.