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?