We are a fabless semiconductor company. Our product flow consist of these building blocks.
1. Wafers - The wafer will be manufactured and be assigned a unique Wafer Lot and then each wafer will have a unique s/n inside that lot.
2. Assembly - The wafers will then be assembled into individual packages and be assigned an Assembly Lot code and a Date Code (for the batch). (This lot may be 50K parts and later be shipped to multiple customers)
3. Test - The packages will then go to electrical test and the passing parts will be assigned a unique Test Lot.
4. Tape and Reel - The tested lot will then go to be taped and reeled and be assigned a unique Tape and Reel Lot with each reel having a unique s/n inside the lot.
5. Customer - Individual serialized reels will then be shipped out to the various customers with each reel having a label that identifies the
These processes are in different factories and will be in the sequence above but there could be gaps along the way depending on many factors. I need to be able to build the data as each step completes.
This will be used to keep track of manufacturing, shipping and customer ship to and most importantly I need backward and forward traceability using any of the unique identifiers. If, for example, a customer has a question or issue I will ask them for the label information which will include Assembly Lot, Date Code and Reel #. I would need to be able to query and find the entire genealogy of the part. Secondly, I would need to identify all customers this same Date Code / Assembly Lot may have been shipped to.
I am very new at Access 2013 but have some limited knowledge so I think I can do this with some assistance. I am particularly interested if I should create a table for each "block" if you will but then I also question what the one to one, one to many really means and how to set that up. Thanks in advance for your help. I will be checking back to the forum through out the weekend.
Steven