Proper set up of a "Product" table (or tables)
For the CRM solution I am creating, there are many products that eventually have to be selected in an invoice. There are about 7 different types of products, so what I have done so far is create seven separate tables for each of the product types, which contain the specific fields tailored to each product type. Is this the proper way to do it, or will I discover that I have shot myself in the foot later on down the road? I figured this would be the best option because in terms of displaying the data, having a layout for each table and designing a series of buttons to navigate between layouts seemed like it would be the cleanest and most efficient.