Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    87

    Unanswered: normalize table help please

    Good afternoon, I need some assistance normalizing a table in Access 2016. The field that concerns me is the invDate field. I have attached a .pdf file that has the contents of the file and I have also attached a screenshot of the table relationships. Please let me know what other info you might need to help with this. I have been struggling with this for a long time. I know that there is a problem, I just don't know what to do about it.

    Thanks, Scott
    Attached Thumbnails Attached Thumbnails realtionshipScreen.jpg   inventoryForm.jpg  

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,482
    Provided Answers: 11
    MY Rules for tables are

    the PK is the samename as the Table with the ID at the End

    FK is the TableNameID

    When you are Make Querys and you drop the differance table in
    MSaccess put the The Join line in for you Because the name are the Same



    dont know why you would have a Table for dates I cant think of a reason why you would want that
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Mar 2013
    Posts
    87
    I would love an alternative to the dates. I need to record when the inventory is conducted. I am concerned about how to store the date. Thanks, Scott

Posting Permissions

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