Get information from another field but not making it dependent
So, I am converting an old excel spreadsheet into a File Maker Pro 11 database.
Our current setup for age ranges was a field for Age 19-29 (marked with an "X"), Age 30-44, ("X"), Age 45-64 ("X"), 65+ ("X")...
Using Case, I setup an AgeCalc field, that sets the value to "19-29" if field "Age 19-29" has an "X", and so forth.
I want to have just an Age field, that I will eventually use a radio button setup for on the data entry layout.
How can I set the Age field to be the value of the AgeCalc field, but not make it dependent on it (so I can delete the old age fields and the AgeCalc field when done)...
or will I have to do it manually? Thanks!