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.
16th April 2012, 03:20 PM #1
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.
16th April 2012, 03:37 PM #2
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
Thanks to bossman from:
SHimmer45 (16th April 2012)
16th April 2012, 04:09 PM #3
thanks looking at the link and adjusted the tables and see if that helps
By BatchFile in forum General Chat
Last Post: 22nd June 2011, 10:31 AM
By PEO in forum Graphics Requests
Last Post: 12th April 2010, 11:14 PM
By kennysarmy in forum Windows
Last Post: 25th March 2010, 11:40 AM
By Ric_ in forum Thin Client and Virtual Machines
Last Post: 16th July 2007, 12:15 PM
By Dos_Box in forum General Chat
Last Post: 9th May 2006, 11:36 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)