Create my own Unique ID number to track records and link records in different tables instead of using AutoNumber
Posted on 2007-10-04
I have a two Excel Spreadsheets,rds and the second contains 4000 records. I have converted the files into Access called tblPartInventory (6000 Records) and tblPartTransfer (4000 records).
When I receive a new part, I enter the PartName, PartNumber, and VendorIDe information into a table called tblPart. When I have to catalog the part and place it on the shelf, I add a Barcode number, part serial number, and additioal part information into to a recvord in tblPartInventory. When I have to transfer the part, the part information is deleted from tblPartInventory and moved to tblPartTransfer.
Both excel files that I received do not have a unique product ID, that can be associated with a part's PartNumber or BarcodeNumber, therfore I canot create a one-to-on or one-to-many relationship. The data was just entered into colums on the spreadsheet and as a result; I cannot use the Parts Barcode Number, Part Number or Part Serial Number because 50% of all the fields are blank.
Please help me come up with a way to assign a unique ID number to all related records in both tables that can be added to an partID field the same way Access AutoNumbe works each time I create a new Inventory record. I would perfer not to have to enter the unique on each line manually.