How to make receipts with reports.

Hello. Maybe the question isnt about reports at all, but i have a
problem of making a simple database of a shop for example which sells
products to customers, looking through the inventory table and
selecting the what the customers wants to buy with a Yes/No field. but
that creates a problem of quantity..unless i create another field
which in some function or condition will multiply the price.... and
then keep it in the database with the current day to be like a
shoppers history... but that seems too much for something that
simple... can anyone give me an advice or an example of a simple shop
database with a product list... and someway to make some type of
receipts on reports...

Thanks in advance

Look at how online stores do it. Their methodology seems very standardized
now. The "Shopping Cart" idea is what I'm thinking of in particular. I
presume this is just a separate, temporary table. Seems pretty
straightforward.

As for reports that look like receipts, I don't see the problem. Just set up
your fields so that the report looks like a receipt.

"K" wrote in message
oups.com...
Hello. Maybe the question isnt about reports at all, but i have a
problem of making a simple database of a shop for example which sells
products to customers, looking through the inventory table and
selecting the what the customers wants to buy with a Yes/No field. but
that creates a problem of quantity..unless i create another field
which in some function or condition will multiply the price.... and
then keep it in the database with the current day to be like a
shoppers history... but that seems too much for something that
simple... can anyone give me an advice or an example of a simple shop
database with a product list... and someway to make some type of
receipts on reports...

Thanks in advance

On Apr 22, 6:26 pm, "David Portwood" wrote:
Look at how online stores do it. Their methodology seems very standardized
now. The "Shopping Cart" idea is what I'm thinking of in particular. I
presume this is just a separate, temporary table. Seems pretty
straightforward.

As for reports that look like receipts, I don't see the problem. Just set up
your fields so that the report looks like a receipt.

"K" wrote in message

oups.com...

Hello. Maybe the question isnt about reports at all, but i have a
problem of making a simple database of a shop for example which sells
products to customers, looking through the inventory table and
selecting the what the customers wants to buy with a Yes/No field. but
that creates a problem of quantity..unless i create another field
which in some function or condition will multiply the price.... and
then keep it in the database with the current day to be like a
shoppers history... but that seems too much for something that
simple... can anyone give me an advice or an example of a simple shop
database with a product list... and someway to make some type of
receipts on reports...

Thanks in advance

If only there was an example... of that shopping cart... i have
already request in another topic..but if you can give any hint... i
would be more then thankful