+ 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
    669
    Thank Post
    28
    Thanked 77 Times in 72 Posts
    Rep Power
    22

    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,753
    Thank Post
    1,508
    Thanked 1,290 Times in 881 Posts
    Rep Power
    812
    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 01:58 PM.

  3. #3

    StevieM's Avatar
    Join Date
    Apr 2013
    Location
    Liverpool
    Posts
    1,209
    Thank Post
    515
    Thanked 566 Times in 372 Posts
    Rep Power
    148
    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
    669
    Thank Post
    28
    Thanked 77 Times in 72 Posts
    Rep Power
    22
    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
    669
    Thank Post
    28
    Thanked 77 Times in 72 Posts
    Rep Power
    22
    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
    1,209
    Thank Post
    515
    Thanked 566 Times in 372 Posts
    Rep Power
    148
    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
    669
    Thank Post
    28
    Thanked 77 Times in 72 Posts
    Rep Power
    22
    yeah, its been ages since i last used access properly....



SHARE:
+ Post New Thread

Similar Threads

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