I see a lot of tables that look like: Customers->Orders->Products
But in my case, I can't seem to lay it out that same way, and it makes me think I'm doing something wrong. In short, a "Products" table will not work because the products offered have no features in common, yet still need to be linked to an Orders table. As an example, look at the attached pic showing a Relationship: "tblFlooring" and "tblCountertops" have fields unique to them, yet share certain administrative information shown in the orders table like the Date it was placed.
Maybe this is completely normal, but I can't tell. I always see examples in books and on tutorials of strictly linking each table to the next, one after the other, like a chain. I came up with this way on my own and it feels alien to what I've learned so far.
More still, "tblFlooring" and "tblCountertops" are just the beginning, I could throw in 6 or 7 other products each needing specific tables of their own.
Thank you for any input,
Matt