Forum Discussion
- _anomDiebolt_Qrew EliteYou cannot revive a deleted record. In general [Record ID#] values should not have any significance.
- SameerSameerQrew TraineeDo we have any possibility to add the record in place of missing [Record ID#] i noticed that Record ID is not modifiable, if we have any chance then please suggest
- _anomDiebolt_Qrew EliteI suppose you could create a new table and port over all your existing data including a manually reconstructed record for the deleted one. However, you have to do extra work to rebuild the relationships to the new table and delete the old table.
I think it is better advice to not rely on the significance of the [Record ID#] value. - QuickBaseCoachDQrew CaptainSameerr, if it is important to retain the 114 as an identifier if the record, you can enter a new record and have a field called identifier override.
Then use a formula such as
If ([Identifier override] > 0 , [Idenifier override], [Record ID#])
Then show that field in view mode on Forms and on Reports.