Varied Layouts - dependant on input info
I have a database used for engineers to check machinery in a factory.
The data base has the following tables: Products - Assets - Customers - Test Results
Certain products and Assets have different tests from others, and so need different Test Results layouts.
How do I set it up so that when inputting an asset number into the test results table, the layout is dependant on the asset?
(there will be 3 layouts required for Test Results)