I currently have an excel log that is used to record our non-conformance data.
I am trying to setup an access database to record the above information and I would like the data to be entered using an user form.
I have limited experience using access and so far have messed around with a few examples. Out of this I have a few questions on how to set up the database correctly.
1. What is the best way to set up the tables?
These are the fields:
Non conformance number – Number format
Date Opened
Initiator – Would like this to be selected from list
Defect Owner – Would like this to be selected from list
Shift – Would like this to be selected from list
WorkCentre – Would like this to be selected from list
Major Quality Issue – Yes/No
Prd Number - – Would like this to be selected from list, If a number is picked it would autofill in the next 2 fields
Prd Description – See above
Material Type – See above
Material Defect – This would relate to the material type (again a drop of options)
Defect Description – General comments
Initial Amount – Manual input
Unit of Measure – Select from list
Initial Cost – This would be a calculation of the initial amount by unit cost (this is tied to the prd number field)
Supplier – Select from list
Supplier Details – auto fills from supplier picked
Final Disposition – select from list
Final Amount – manual input
Final Cost This would be a calculation of the final amount by unit cost (again this is tied to the prd number field)
Date Closed
Can anyone give me the best advice to lay this out.
Thanks in advance for your help!