Hello and Thank You in advance.
I was always a newbie but did manage to complete several DB projects in the past, but its been a few years. I just could use some direction on how to complete this one. Not afraid of slogging thru google, text books and the like to relearn but would appreciate how someone experienced might set up this project so I design it effectively.
A Distribution Kitting Project.
Overview Step One: Customer has Units it now wants to sell as kits of two. Each kit will have a New Serial Number that needs to be associated to the two individual old serial numbers. (I can use a barcode scanner to collect these three pieces of data.) My issue is to assure the correct data collection and to NOT allow Duplicate Kit Serial Numbers nor Duplicate Unit serial numbers at the time of data collection. If the associate accidentally scans the same serial number twice I need to have the Access Form stop and require them to rescan the correct one. (I believe the answer here is two tables: One for the Kit Serial Number and one for the Unit Serial Number and use a form to update both. But, I'm not sure I can have two data entry fields for the same field in one form.)
Overview Step Two: (At a separate work station, located away from first work station.) Now, I need to capture Two of the Kit Serial numbers and have them associated to a unique Master Carton Identifier Code and a the Master Carton Identifier Code to a unique Master Skid Code. (I already know that 100 Master Cartons make a Skid so, my Master Carton Identifier will already be associated to a Unique Skid ID. The Skid ID will be prominently displayed so the associate stacking the skids will know which skid the master carton needs to be placed on.) So, very similar to above but, at a case level. Again, One Unique Carton ID to Two Unique Kit Id's. And of course need to make sure that if an associate scans the same Serial twice it doesn't get entered.
Overview Step Three: If, I can get the above to process correctly, I'm working with BarTender a labeling software to Print the Carton Label since, it has to print some of the data just collected. (The serial numbers of the two kits inside that carton. This label software can link to an Access DB.)
Overview Last Step: I need to compile a report from the data collect at both PC Stations to a Master Data report to send to the customer which contains: (I haven't done it yet but believe I remember reading that multiple devices can update the same DB.)
- Kit Serial to Two Unit Serials
- Master Carton Identifier to Two Kit Serials
- Skid Identifier to 100 Master Carton Identifiers.
Well, I hope someone can assist. I don't want anyone to do the work... I'm fine as I said with relearning what I need to do in Access. But some helpful hints in the correct direction would be GREATLY appreciated! Dave