I have a situation , I have more then 400 records in list. The list form is using SQL request control which is connected to a text field. Now the data in SQL control is changed (the lookup data is renamed in the lookup table).
Eg. the old data was
1. Division 1
2. Division 2
1. Division 1 new
2. Division 2 new
So if I open an existing form the sql request control will be blank. It will be blank even if I update in the list text field with the new data.
Is there a way to update the form data without opening the form one by one.