AnsweredAssumed Answered

Changing matched field

Question asked by dantrue on Feb 8, 2018
Latest reply on Feb 8, 2018 by keywords

I have a portal connecting ItemsTable to InstancesTable, where each Item has multiple Instances and the tables are matched by the ItemID. If I change the ItemID, the associated Instances are "lost" because the IDs no longer match. How can I change all the ItemIDs from the original name to the new name in the Instances table?

 

 

I thought about making a permanent ID that is invisible to users but is used for relationships, but it would be quite a bit of work to change all the tables to use permanent IDs and it still wouldn't fix the mismatched ItemIDs.

Outcomes