Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Cheltenham, Gloucestershire, England
    Thanked 0 Times in 0 Posts

    entry of records (2000)

    I have an inventory to catalogue in access for a charity. The larger items are "loaned" to customers. These items need individual entries with serial numbers because they have to be regularly serviced - e.g. electrical goods . Other items are stored in volume (e.g. shoelaces) and issued to customers with no record needing to be kept of who has them, merely a note to rerder for stock.

    I have no trouble setting up the various tables to deal with the individual items and recording the location and tracking their service history. But how do I deal with the multiple small items - I don't fancy entering 400 pairs of shoe laces in 400 separate rows each with their own id number.

    Can anyone suggest how I can make these two types of stock live harmoniously in the same database?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts

    Re: entry of records (2000)

    How about a master record for each kind of item, and a second table with just the ID number of the master record, serial number, service dates, location, etc. Quantity could be tracked in the master record, and check-out or withdrawl transactions would simply reduce the quantity on hand. Let us know what you think.

Posting Permissions

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