How to compare records within the same custom table and update a reference field.

Nadeem Basha
Tera Contributor

 

Hi Team ,

Is there any script that can be written to compare records within the same table.

I have got a custom table that has records belongs to the year 2023,2024 and the problem is in the records that belong to 2024 ,there is a reference field called "Last year" which displays empty.

Expected behaviour is that the "Last year" field should have been mapped with the respective 2023 records and that means for every 2024 records there was already 2023 records available in the table but it was not  mapped .

Is there any script which can be written in the backend to map the 2023 records with respective 2024 records ?.

 

Thanks

0 REPLIES 0