+ Post New Thread
Results 1 to 7 of 7
Office Software Thread, Access Relationships in Technical; Hi all been tinkering with access to create an order DB. would someone have a butchers at this and tell ...
  1. #1

    Join Date
    Sep 2010
    Posts
    564
    Thank Post
    26
    Thanked 62 Times in 58 Posts
    Rep Power
    20

    Access Relationships

    Hi all been tinkering with access to create an order DB.

    would someone have a butchers at this and tell me if i have missed anything obvious in how its setup, before i start attempting to create reports and then find the table setup is wrong....
    relationship.jpg

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,487
    Thank Post
    1,445
    Thanked 1,182 Times in 809 Posts
    Rep Power
    709
    Purely from a "Best Practise" point of view, I'd create separate tables for orders and items, otherwise you'll end up with dozens of duplicate items

    Ignore me, you've already done that!
    Last edited by LosOjos; 6th November 2013 at 12:58 PM.

  3. #3

    StevieM's Avatar
    Join Date
    Apr 2013
    Location
    Liverpool
    Posts
    858
    Thank Post
    338
    Thanked 368 Times in 247 Posts
    Rep Power
    111
    The relationships are all correct, although I'm wondering why have you set the Supplier_Name field as the primary key and not the Supplier_ID.

  4. Thanks to StevieM from:

    SHimmer45 (6th November 2013)

  5. #4

    Join Date
    Sep 2010
    Posts
    564
    Thank Post
    26
    Thanked 62 Times in 58 Posts
    Rep Power
    20
    i think thats a mistake.... oops
    at least the relationships are ok.
    think i need to add in some extra bits for the item subtotals into the order table as adding it into the item table is wrong

    been putting some live data into it and seeing how it pans out.
    i dislike the access interface

  6. #5

    Join Date
    Sep 2010
    Posts
    564
    Thank Post
    26
    Thanked 62 Times in 58 Posts
    Rep Power
    20
    changing the relationship gives me an "intermediate" relationship type which is why i used the supplier name so it was a one to many
    relationship2.jpg

  7. #6

    StevieM's Avatar
    Join Date
    Apr 2013
    Location
    Liverpool
    Posts
    858
    Thank Post
    338
    Thanked 368 Times in 247 Posts
    Rep Power
    111
    Did you attempt to change it after the tables were populated with data? (Not used Access in a LONG time so may be a little rusty, but I'll help if I can.)

  8. #7

    Join Date
    Sep 2010
    Posts
    564
    Thank Post
    26
    Thanked 62 Times in 58 Posts
    Rep Power
    20
    yeah, its been ages since i last used access properly....

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 16th April 2012, 04:09 PM
  2. [MS Office - 2007] Access - Relationships
    By MatthewL in forum Office Software
    Replies: 6
    Last Post: 18th March 2011, 07:37 AM
  3. Replies: 4
    Last Post: 17th January 2011, 02:36 PM
  4. [MS Office - 2007] MS Access 07 - Relationships problem
    By edd in forum Office Software
    Replies: 20
    Last Post: 15th May 2009, 06:20 PM
  5. Accessing work from home.
    By eejit in forum Windows
    Replies: 33
    Last Post: 1st June 2007, 01:47 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
  •