Using the same value list from one field to another without changing record information
I have records that have been filled out through an import of an Excel file into Filemaker. I want to create a value list based off the values noted in one field, but would like to use this same value list in a second field. I know that can be done, just need to know if doing that would change the information that is currently in the second field that was already imported. For example, the record for the second field might say "XYZ", but it might not be in the value list from the first field, but I still want it to read "XYZ" and possibly add it to the value list. If that's not possible, how can this be done?
A field formatted as a drop down list will display the current value of the field even if the value is not in the current value list.
To add the value to the value list when it is based on a different field would require that the value be entered into the first field of a record in that table.