If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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??? |
#2
|
|||
|
|||
Designing cash registry software
"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 |
Thread Tools | |
Display Modes | |
|
|