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 ...
6th November 2013, 01:12 PM #1
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....
6th November 2013, 01:56 PM #2
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.
6th November 2013, 02:13 PM #3
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.
Thanks to StevieM from:
SHimmer45 (6th November 2013)
6th November 2013, 02:49 PM #4
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
6th November 2013, 02:54 PM #5
changing the relationship gives me an "intermediate" relationship type which is why i used the supplier name so it was a one to many
6th November 2013, 03:07 PM #6
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.)
6th November 2013, 03:08 PM #7
yeah, its been ages since i last used access properly....
By SHimmer45 in forum Coding
Last Post: 16th April 2012, 05:09 PM
By MatthewL in forum Office Software
Last Post: 18th March 2011, 08:37 AM
By browolf in forum Scripts
Last Post: 17th January 2011, 03:36 PM
By edd in forum Office Software
Last Post: 15th May 2009, 07:20 PM
By eejit in forum Windows
Last Post: 1st June 2007, 02:47 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)