Solved Starting Again - Table Relationships.

[Tieval]

Oh, and Pat, you are correct the colours are terrible.

I tend to deal with the operational side of things and it should therefore all be default grey black and white but I have the tendency to play with looks while I am thinking about more important things and my development work always looks a mess

 

[Pat Hartman]

As long as you're happy and you never need to expand, the "clever" but unnormalized solution will work. Expanding using the "clever" solution requires code, query, and form changes which is one of the main reasons to normalize from the beginning. In a properly normalized solution, you would only have to add a row to the motorcycle table and then link it as appropriate to the parts (which you have to do with your accepted solution also). No code, query, form changes required.