I have 2 data based. Main DB and Persons DB.
Records are given an ID in the main db...i.e. 18-123, 18-456, etc.
Records in persons db are give there own sequence number 1,2,3, etc and attached to the main db. i.e 18-123-1 , 18-123-2 , 18-456-1.
I have to do a 1 time import several records from a 3rd party into both Databases. Both have the main number for both databases. The 3rd party doesnt have a sequence number. How do I auto generate and assign a sequence to those records? Right now persons database has records listed like : 18-123, 18-123, 18- 456. I need to assign the 1, 2 etc.
thanks in advance.