AnsweredAssumed Answered

How can I set a sequence number for exiting records.

Question asked by marcm on Sep 19, 2018
Latest reply on Sep 19, 2018 by philmodjunk

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.

Outcomes