Assign Customer number
I have a database with 1 Table. I am finally going to a multi table database. I will have a Contacts Table and then other tables that relate to Contacts by Customer Number. Presently the 1 table has the contacts but each contact may have several records. I want to assign a Customer Number to each customer in the present table before I transfer the data to the new file. Sort of a De-dupper script but that will assign a number to set of records that match each other. Any thoughts?