EH_SG's latest activity

  • E
    EH_SG replied to the thread A normalisation question.
    Numerous Lookup field in numerous tables - why is this bad and what is the alternative? Some of your Joins between tables do not have...
  • E
    EH_SG replied to the thread A normalisation question.
    I have tried to improve the relationships view to make it clearer how everything works together currently. I do have junction tables...
    • DatabaseRel2.png
  • E
    EH_SG replied to the thread A normalisation question.
    These tables log each stock transaction for inventory, sections and products respectively
  • E
    EH_SG replied to the thread A normalisation question.
    Inventory, Sections and Products - each then has its own transactions table, which should maybe be 1 table also if I merge the initial three
  • E
    EH_SG replied to the thread A normalisation question.
    This is a back up of the tables (only) I created before I moved them to sharepoint so its not exactly like this now but the structure is...
  • E
    I created a database for my employer 2 years ago, initially to track component stock though it has broadened to encompass more. It...
    • DatabaseRel.png
Back
Top Bottom