I am sure there are thousands of shop databases out there. I need to build one for a small retail business prototype for my university project, well I have started but having a few problems. Linking customer orders to stock and creating transaction. I need to all this via forms and sub-forms but if i use the same ID (stock ID) twice then there are problems with links . The user input needs to be minimal ie they do not have manually enteer stock into the system.
I have attached a zip of what I have done so far if it makes sense to someone. It is not that bad so please have look and see if you can help.
I would be grateful if some one could give me an example of a Shop DB or one that that was created for a shop of some sort.