[ms office - 2010] Access Relationships

[SHimmer45]

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....

[LosOjos]

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!

Edited November 6, 2013 by LosOjos

[StevieM]

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.

[SHimmer45]

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

[SHimmer45]

changing the relationship gives me an "intermediate" relationship type which is why i used the supplier name so it was a one to many

[StevieM]

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.)

[SHimmer45]

yeah, its been ages since i last used access properly....