Dear Speaker 86,
Initailly, I had started with two tables. I combined them for two reasons-
1. some manufacturers are also vendors which was leading to unnecessary duplication of entries. It also played havoc with data entry, I had to enter the same data twice, once into the Manfacturer...