How to renumber a set of records?
I have an existing set of about 700 records. Each record has a manually assigned number. Turns out there are some duplicates in (e.g., two "501"'s). There were also some records numbered to fit "be...
Forum Discussion
you'll want to insert new number into all the reports and forms where 'oldnumber' was. go to the field properties on 'oldnumber' and view the usage tab, replace oldnumber everywhere it exists, then delete oldnumber.
A lazier option that I often use is to convert old number into a field type formula - numeric. Set old number = newnumber. then convert oldnumber back to a regular numeric field. this saves time and effort if you have alot of reports and forms to update
A lazier option that I often use is to convert old number into a field type formula - numeric. Set old number = newnumber. then convert oldnumber back to a regular numeric field. this saves time and effort if you have alot of reports and forms to update
