Results 1 to 2 of 2
  1. #1
    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.


  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    id number,
    name varchar(20),
    qty number

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts