K
Kerry
Access 2003. I have created 2 linked databases for our receiving dept
records. The Raw Materials db has p/n, description, fixed location, and shelf
life (days). The Lot Number db has p/n, receipt date, vendor lot #, and our
lot #. The issue is the way our company creates lot #’s. We use the p/n,
year (single digit), and the last 3 digits incremented (i.e.: 32754-9001,
32754-9002, 1193225-9001, and 1193225-9002). The lot # is used for FIFO when
pulling for the plant thus the incremental last digits. Question: Can Access
create the lot # and store it in an indexed – no duplicates field in the Lot
Number db? I have a form for initial entry of the p/n, description is
imported, vendor lot #, receipt date, and need our lot # to either Access
generate or show existing lot #’s for the p/n so that we type in the next
available lot #. I would also like to print Avery labels for the receiving
personnel to apply to the material with this info.
records. The Raw Materials db has p/n, description, fixed location, and shelf
life (days). The Lot Number db has p/n, receipt date, vendor lot #, and our
lot #. The issue is the way our company creates lot #’s. We use the p/n,
year (single digit), and the last 3 digits incremented (i.e.: 32754-9001,
32754-9002, 1193225-9001, and 1193225-9002). The lot # is used for FIFO when
pulling for the plant thus the incremental last digits. Question: Can Access
create the lot # and store it in an indexed – no duplicates field in the Lot
Number db? I have a form for initial entry of the p/n, description is
imported, vendor lot #, receipt date, and need our lot # to either Access
generate or show existing lot #’s for the p/n so that we type in the next
available lot #. I would also like to print Avery labels for the receiving
personnel to apply to the material with this info.