I am in the Quality Dept and have a DB for our product specifications. Key field is PRODUCT ID. To get the PARAMETERS (length, width, ect) in correct order I use a field called ORDER. (Each parameter has min, target, max, and notes fields)
I want the Maintenance Dept's and the Engineering Dept's to edit their own tables that have fields PRODUCT ID, PARAMETER, and ORDER.
I want my query and reports to list the Quality Dept parameter's for the PRODUCT ID first in correct order, the Maintenance Dept parameter's for the PRODUCT ID second in correct ORDER (FIELD), and the Engineering Dept parameter's for the PRODUCT ID third in correct ORDER (FIELD)
a. If I add department ID codes will my query allow me to get 3 Dept's data on the report? The query I will create will have a lot of fields for QA (min, target, max, notes), Maintenance (min, target, max, notes), and Engineering (min, target, max, notes).
How do I do this? - It won't work. Out put of the query will have each line blank
Is this too complicated?