I am about to create an Access Database for a company that Has a few diverse product lines.
I want to have a different table/form for each type of product
Example
tblArtGlass
tblCoatings
tblBricks
I want to be able to create elaborate Pricing engines and track other product specific details with completely different Tables/Forms.
When Creating work orders or placing orders,
I want to be able to see and choose from all the Separate product tables but be treated as a single product listing.
Will a Union Query do what I need?
How do I link it all together with primary keys.