For what it's worth, I think you're headed for trouble. You may expect a single order to be "linked" to a single vanity top, but what if I order one for my kitchen and one for the bathroom? Or what if I'm a contractor and order several at once for various jobs? Then there is the notion of having a form for each product plus adding tables and forms for each new product, to say nothing of what to do with any discontinued product. For this,
...cannot share the same table due to having dissimilar field names/types
I cannot imagine the tables as having been set up correctly. I've seen parts tables for everything from tiny fasteners to huge rolling mill components - all in one table. If your descriptions/product characteristics are so different that there would be too many null fields in a products table, there ought to be description tables that deal with groups of characteristics with the product key as an FK.
Last edited by Micron; 06-26-2017 at 11:57 PM.
Reason: fixed tags
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.