
Hello, i would like to get help for my problem.
I have SQL table "db.Asbestos_Sampling", all record have columns ID, old_record, new_record.
Created record cannot be edited or deleted. Could be only replaced by new record but have to be to intertwine. Therefore when i repair of record i need save new record ID to old record and old id record to new record.
When im go from original record screen im set his ID record to variable _OldId. If _OldId not blank so field with oldid is visible and will be save. This is easier step.
But now if i want save this replacement record (new) i need save his ID to old record to column "new_record".
How could i make it?