Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2016
    Posts
    1

    Exclamation Unanswered: What Kind of Database Should I be Using?

    Good afternoon All,

    I work for an HVAC company, we sometimes stock refrigerators & ice machines for Starbucks store. When we get new stock for a Starbucks store, we need to log it in as their new product, connecting the product to the correct Starbucks store (sorted by store # & name).

    Would it be best to use Microsoft Access for this? Any help is greatly appreciated.

    Thanks
    Alysa

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    MS Access will work just fine for this kind of thing! In broad stokes, you'll basically need two Tables:

    tblStores
    StoreID (Primary Key)
    StoreName
    StoreNumber
    StreetAddress
    City
    State
    Zip
    etc.

    tblProducts
    StoreID (Foreign Key)
    ProductID
    ProductName
    ProductSerialNumber
    DateReceived
    DateDelivered
    etc.

    You'd then use tblStores as the RecordSource for a Main Form, and tblProducts as the RecordSource for a Form to be used as a Subform on the Main Form.

    When you add the Subform Control to the Main Form, and select the Products Form as the source, Access should automatically join the Main Form and Subform using the StoreID Fields in both. When you add a new product Record to the Subform, Access will automatically populate the correct StoreID in that Record.

    A single Record for each store will be in the Main Form, with one or more product Records, per store, in the Subform. As you move from store to store, in the Main Form, the products in the Subform will change, appropriately.

    Welcome to dBforums!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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