Re: Changing Value Lists

On Feb 19, 10:38 pm, buck.matthe...@xxxxxxxxx wrote:
I am thinking of renaming some of the values in my value lists. I am
guessing my function equations will not update. Is their a way to see
a list of the effected functions as an alternative to trolling through
my table fields one at a time?

Anything in quotes won't update. E.g. Case(value = "gold"; 1). And
you change the value list item gold to yellow, "gold" won't change to
"yellow".

You can use the Replace function by calc to batch change records
pretty quickly.
Case(value = "gold"; "yellow"; value = "maroon"; "red"; value)

One way to stop this in the future is to not use custom value lists,
but tables for value lists and the primary key instead of the word
itself.
.

Relevant Pages

  • What to Prepare For -- My Views
    ... A couple of on-topic "preparation lists" have hit the forum lately. ... Days -- Water, and rest/sleep, with implications for shelter, ... Weeks -- Food. ... What about gold? ...
    (misc.survivalism)
  • Re: What to Prepare For -- My Views
    ... gotten my core lists implemented to my satisfaction. ... Bugout bag, whatever, come from the answerto this question. ... water heater could be used, about LED flashlights, etc. ... interest in trading with gold that the new value will be established ...
    (misc.survivalism)
  • Castle Garden Era Immigration to Other U.S. Ports
    ... I have searched diligently but fruitlessly for my KURTZMAN and GOLD ... ancestors in the Castle Garden lists, both the version Steve Morse has made so ...
    (soc.genealogy.jewish)
  • Changing Value Lists
    ... I am thinking of renaming some of the values in my value lists. ... guessing my function equations will not update. ...
    (comp.databases.filemaker)