how do I reset record id back to 1?I have deleted all records[App management-Delete all records -Choose table] . New record got created with record id 17 instead of 1.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hello,

Thank you in advance for looking in to this question.

QB- Form record id : How to setup back to 1 after deletion of all records. 


Thanks,

Bhumika

Photo of Bhumika shah

Bhumika shah

  • 0 Points

Posted 4 years ago

  • 0
  • 1
If you make a Copy of your app without data, then all the Record IDs get reset to 1.

But you cannot reset an individual table's Record ID field.
Photo of Bhumika shah

Bhumika shah

  • 0 Points
Its' look like I don't have permission to do so. Is there any other option where I can set table record to 1.  I have deleted all records only from 4 main tables(Proposed Assets, Assets, Maintenance note, deployment notes) and would like to maintain data in other lookup tables.

Thanks,
Bhumika
No other options.  Why do you care what the Record ID is?  Is there a reason?