Table Relationships

[mdlister]

Can anyone look at this pdf and let me know if my relations are correct, i know i haven't marked on if its one to many etc but i just need to know if it'll work?

 

[RuralGuy]

It looks fine except I suspect you tblMake and tblModel are in a 1 to 1 relationship and might as well be in the same table.

 

[mdlister]

thanx

hey, thanx for the advice tho its a one to many relationship between the make and model as theres only one make ie cannon and many model numbers for that specific make.

 

[RuralGuy]

Cool...