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
So I imported the exact amount of records to the new table and then tried the update. Same result...
|
------------------------------
Joshua Kaye
------------------------------
Did you import the same # of records or up to the max record id # in the old table? You may only have 5000 records in total - but if you had deleted records in the old table the max record ID might be 5050 and in the new table you would need to import all the way to that number.
------------------------------
Chayce Duncan
------------------------------
Where do I get that count? I was looking at the LIST ALL report.
------------------------------
Joshua Kaye
------------------------------If you're running a list all, just make sure that Record ID# is in the report and then click it to sort largest to smallest and the biggest # is the one you're looking for. For example:
I have this table that has 75,102 record but the biggest RID in my table is 174,155 by sorting on that column.
------------------------------
Chayce Duncan
------------------------------Thank you! It worked. I really appreciate the assistance. Josh
------------------------------
Joshua Kaye
------------------------------