Results 1 to 4 of 4
  1. #1
    Mariam is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2020
    Posts
    1

    Design table relationship for multiple stores

    Hi everyone,




    We have 2 stores containing different items. Multiple items can be found in different stores but with different quantities. Attached is excel file for the stores items.
    I need to make the following scenario.

    Every employee can ask for multiple orders to departments from the stores

    Each order contains multiple items

    each item can belong to different stores

    each store contains many items

    each store can have the same items but with different quantities


    I am completely missed up. I don't know how to manage the similar items in different stores with different quantities in each store.


    Please help me to put the first design of the table relationship.








    I don't know how to set table relationship between stores, items, employees, and even if wee have have supplier tables.
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Access(database) is quite different than Excel(spreadsheet).
    For practical experience / learning of database tables and relationships spend 45-60 minutes and work through one or two of these tutorials from RogersAccessLibrary.
    ZYX Laboratories ***recently added
    Class info system
    Catering Business
    Widgets

    Good luck with your project.

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Mariam

    When an Employee asks for an Item does it matter which Store it comes from?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Mariam

    I have put together a couple of tables and Forms to show you how tables could be constructed,

    This is just an example as I do not as yet know your business rules.

    The Form that opens allows you to create a Request on a Specific Date and then add a Number of Items for that Request.

    This layout is known as a Main Form (Parent Table ) which is related to a SubForm (Child table)

    Come back with any questions required.
    Attached Files Attached Files
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Table Design - Relationship Structure
    By djspod in forum Database Design
    Replies: 2
    Last Post: 03-09-2017, 10:43 AM
  2. Replies: 3
    Last Post: 03-17-2015, 12:57 PM
  3. poor table relationship design
    By dsm2000 in forum Database Design
    Replies: 3
    Last Post: 10-26-2014, 11:50 PM
  4. Table and Relationship Design
    By GrayWolf in forum Access
    Replies: 6
    Last Post: 01-31-2012, 02:04 PM
  5. Multiple Table Relationship Design
    By neo651 in forum Database Design
    Replies: 1
    Last Post: 09-30-2011, 01:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums