What is best way to replace the table on a reference field without losing data on existing records

[priyakumar]

There is a reference field/variable on a catalog item which is referenced to table A. Now due to process updates we created a new table and want to update the reference field with the new table. But doing this is clearing the field/variable data on existing RITMs. Please give us your recommendations on how to do this the right way without losing the existing data

We need to update a reference field to a new table without losing the data on existing records.

[Geoff_T]

Hi,

Just make the existing variable inactive and create a new one to reference the new table.

Geoff

[Hitoshi Ozawa]

Hi Priyakumar

To keep the reference intact, it is better to create a new field as Geoff replied. However, this will imply fixing the scripts to also use the new field to the new table. Forms and reports using the old field will also need to be updated to use the new field.

As caution, if the name of the old reference field is changed, all the references be deleted so it is advisable not to change the old field's name.