Access 2010 - Relationship Diagram Does this look correct

[SHimmer45]

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 stand

 

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.

[bossman]

@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

[SHimmer45]

thanks looking at the link and adjusted the tables and see if that helps