Designing cash registry software

[Guest]

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???

 

[Arvin Meyer]

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