Sales Receipts in Access Database

Citadel535

Senior member
Jan 16, 2001
816
0
0
I am trying to put together a database that will keep track of the items that are sold in a receipt. I can't figure out what would be the best way to do this.

A receipt would hold the following information:

(#) (Product Name) (Quantity) (Price) (full price)

So a sample receipt would list this:

1 Joe's T Shirt 2 9.99 19.98
2 Khaki Pants 1 34.99 34.99

How would I track the items sold in a field? This way when I look up a receipt later on, it lists the products sold in it.

Please help me out! Thanks in advance! :)