Designing cash registry software

I want to design a cash-registry software for my computer to use in my stores. The objective is to create a realtime inventory database, so that I can send Just in time orders to resupply. I created a number of tables and forms, but got stuck when trying to create the cash registry functions.

How do I achieve the following?

Create an undefined amount of transactions on one reciept with an indexed receiptnumber?
Create a table daily for each individual days sales automatically (I can't expect the cashiers to do that), so that I can create a daily salesreport?

help, anyone???

"Patrik" wrote in message
...
I want to design a cash-registry software for my computer to use in my
stores. The objective is to create a realtime inventory database, so that I
can send Just in time orders to resupply. I created a number of tables and
forms, but got stuck when trying to create the cash registry functions.

How do I achieve the following?

Create an undefined amount of transactions on one reciept with an indexed
receiptnumber?

Create a form/subform (and underlying tables) similar to the NorthWind
sample database that comes with Access.

Create a table daily for each individual days sales automatically (I
can't expect the cashiers to do that), so that I can create a daily
salesreport?

You only need to 2 tables SalesHeader and SalesDetails. The salesreport
either sorts on the date field or uses a date as criteria for the report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access