I want to create a Table for busines receipts which consists of RetailerName, RetailerLocation, PurchaseDate, then detailed PurchasedItem. Being that some receipts have many items, is there another option instead of making many fields like PurchaseItem1, PurchaseItem2, PurchaseItem3, etc?
Kevin Robertson
@Reply 3 years ago
Take a look at the Invoicing video.
In this video Richard shows how to set up Orders and Order Details. Same concept.
Hank HatakenakaOP
@Reply 3 years ago
Thanks so much for the information Kevin, much appreciated!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
