Importing table with existing Record ID#s
Hello QB Community,
I am creating a new application and I want to preserve the record id # from my original application that is still in use for the ease of keeping data updated. However when i...
Forum Discussion
Hi Joshua!
I believe what you'll want to do is create a field that is specific to that record ID from your old system. So, for instance [OLD SYSTEM_RID] or whatever you want to name it. And then when you import all of your data into the table, you'll go into advanced settings and make that field [OLD SYSTEM_RID] the key field.
------------------------------
Renee Hansen
------------------------------