AnsweredAssumed Answered

Replace (part of) field contents

Question asked by tays01s on Oct 14, 2017
Latest reply on Oct 14, 2017 by philmodjunk

I have a field with products lists on a 'List' table. The lists are different between different record. There is 1 item whose name I'd like to change without changing anything else about the list, but I'd like that change throughout this field.

Q1. Is changing the name of 1 product within all records possible?

 

This problem arose because the name of the product changed so I updated it in the 'Product' table from which the List table derive lists of product names.

Q2. To maintain product concordance/  agreement, is it better practice to add a new product record (ie. a new name for a product that already exists) OR if there's an answer to Q1. might it be better to update the name within the lists?

Outcomes