Hi there,
I am interested to build a database which should be able to control and report Manufacturing Process Alteration Instructions and advise.
The following fields/elements will be participating:
- A Unique Process Alteration No. PK
- Date Process Alteration issued: Date/Time
- Machine/Product ID (* This includes 4 type of information which is already existing in 4 different Tables like Machines, Items, Comp.A, Comp. B)
- Description
* I tried Union Query to combine all 4 tables to feed information to "Machine/Product ID" field but in two tables the description field contains Multi values so it is not effective any more. So can we have a selection option for the user at the top of form so which can lead to the concerned type of data from the related table. Like, if user is going to issues instructions for Process Alteration in "Machines" so he select machines and that table information appears in "Machine/Product ID" and "Description" fields?
- Current Parameters (*This field will be containing the information that the current parameters/Instructions running on that machine/product.)
* How it should automatically appeared in this field when select "Machine/Product ID"?
- New Parameters (The Parameters/Instruction required to change the existing one and implement).
* Some new will be required to type in and some times existing ones will be required to select, so how can provide the list of existing ones?
- There are other fields as well which i can manage like Who Purpose/Initiated this alteration which will be from Team members list then approvals and notes.
Please advise to move on for this concept with better database design.
regards
Zee