Andy Williams..

M

MitziUK

Andy

I am at present improving my database with the suggestions you made and can
see the benefit of this regarding combo boxes on forms etc. However, can you
please explain why i need another further table linking both the Make ID and
Model ID

Andy Williams said:
Link them together with a third table Make/Model

tblMakeModel
fldMakeID, fldModelID
Click to expand...

I assume that the fields Make ID and Model ID used on forms come from the
respective tables and not the one joining both makeID and modelID together.

Thanks
 
Top