Thread: Inventory Control
05-14-04, 18:03 #1Registered User
- Join Date
- Jun 2003
Unanswered: Inventory Control
I've been trying to use the "Inventory Control" template in access 2003.
I've been trying to set the tables to what I need.
I think another template or a boost with this one, I can get it up and going.
I'm helping a friend setup Inventory for a shoe store.
He has several shoes with the: Name, Model, Color, Size.
The problem with the template is: there is a set ProductID
and I always work from scatch without ProductIDs, which is hard
for me to work around.
My goal of the Inventory database is to be able to select on a Name brand and it will show the options of color and size and/or vise versa.
I need to be able to put in how many he has of one brand with model and color and size, then when he makes a sale it will keep count of how many is on hand.
There are about 18 sizes; basic colors and bi-colors. Several brands.
I'm looking on a basic ideal of how I need to do this.
05-14-04, 22:05 #2Registered User
- Join Date
- Sep 2003
- The extremely Royal borough of Kensington, London
insert into tableA (name, qty) values ('name', 10);Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.