+ Post New Thread
Results 1 to 3 of 3
Coding Thread, Access 2010 - Relationship Diagram Does this look correct in Coding and Web Development; dabbling with Access again, did some work on it at college many years ago so very rusty on relationships. attempting ...
  1. #1

    Join Date
    Sep 2010
    Posts
    548
    Thank Post
    26
    Thanked 62 Times in 58 Posts
    Rep Power
    19

    Access 2010 - Relationship Diagram Does this look correct

    dabbling with Access again, did some work on it at college many years ago so very rusty on relationships.

    attempting to setup a basic order database which i can input and output order from, been trying to get the reporting work ing properly but struggling so was wondering if its because the underlying structure is wrong.

    Relationships as they standrelationship.jpg

    Reports are attempted to be ordered via department - order - items but if i trying and put the order total at the bottom after the items it wont let me CONFUSED.

    any help welcome.

  2. #2

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    @SHimmer45:

    I think you have a couple of errors in there to do with foreign keys: first one is in the dept table the dept id should be the primary key and in the order database it should be the foreign key as there could be 2 departments with the same name but not with a unique ID number. You have the general idea with the relationships in the one to many cohort but its the foreign keys which are in my opinion wrong.

    Check this site out it should help you: Database Normalization Basics

    It won't take you long to get back into the swing of it

  3. Thanks to bossman from:

    SHimmer45 (16th April 2012)

  4. #3

    Join Date
    Sep 2010
    Posts
    548
    Thank Post
    26
    Thanked 62 Times in 58 Posts
    Rep Power
    19
    thanks looking at the link and adjusted the tables and see if that helps

SHARE:
+ Post New Thread

Similar Threads

  1. Home Broadband problems - does this look ok to you?
    By BatchFile in forum General Chat
    Replies: 33
    Last Post: 22nd June 2011, 10:31 AM
  2. Does this look ok for a schools MTB Club logo
    By PEO in forum Graphics Requests
    Replies: 4
    Last Post: 12th April 2010, 11:14 PM
  3. Does this look familiar?
    By kennysarmy in forum Windows
    Replies: 11
    Last Post: 25th March 2010, 11:40 AM
  4. This looks interesting - VMware Converter
    By Ric_ in forum Thin Client and Virtual Machines
    Replies: 11
    Last Post: 16th July 2007, 12:15 PM
  5. This looks good
    By Dos_Box in forum General Chat
    Replies: 8
    Last Post: 9th May 2006, 11:36 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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