S'okay for you pro's - I'm petrified to change anything in case I rock the boat!iPads are pretty useless in a Windows environment. a Surface pro would be significantly more useful
The Type and SubType tables have no relationship to each other but they each have a relationship to the product. And please do find better names for them.
The types & sub types have no relationship in access but they do in the mind of the user...But I shouldn't mix the two up - My only excuse for bad practice - apologies Pat