Results 1 to 5 of 5
  1. #1
    xmerrox is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2017
    Posts
    2

    Question Normalization/ Best practices

    Hello all! I am very out of touch with access and would appreciate if anyone has an opinion on my problem.

    I have a db I'm building that relies on a combination of 5 things that each combination has a different static set of results.

    Currently I have two tables that link together as one is the combination of 5 with an ID number and the 2nd table is the results, as I would suppose a 1 to 1 relationship. I'm guessing I created more work for myself in doing the split, but need better opinions if anyone is willing.



    The other possible quandary is that in my form for adding new records, I have to have it check for duplicates in the 5 combinations. I have this coded, and I am pretty sure I can switch it to just the first 5 columns if I need to combine the tables, but I just wanted to mention it in case.

    Thank you immensely to any who offer opinions for my stoop self.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Not enough information. To help us understand, show example data of what you have and what you are wanting.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If tables are 1 to 1 relationship and there will always be related records in both tables, really should just be 1 table. Set the 5 fields as composite index to prevent duplicate combinations.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    xmerrox is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2017
    Posts
    2
    Thank you guys! I appreciate it.

    I always end up over thinking everything.

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

Similar Threads

  1. Replies: 10
    Last Post: 06-20-2017, 12:57 PM
  2. Best practices for archiving old records
    By sjs94704 in forum Access
    Replies: 2
    Last Post: 04-17-2015, 11:51 AM
  3. Access Best Practices
    By jrmbach in forum Access
    Replies: 4
    Last Post: 05-12-2014, 08:23 AM
  4. Best practices and user behavior
    By Lynn Cohen in forum Misc
    Replies: 5
    Last Post: 02-12-2014, 08:51 AM
  5. Best Practices
    By Sinkerhawk in forum Access
    Replies: 2
    Last Post: 06-30-2011, 11:44 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