In light of your comments I have revised the design of my tables and Primary Keys. I now have 10 tables, none with a composite primary key and several with an auto increment primary key. Several tables have composite foreign keys.
I initially installed 2 tables and added the rest a couple at a...