AnsweredAssumed Answered

Get information from another field but not making it dependent

Question asked by RichardAdams on Sep 6, 2012
Latest reply on Sep 6, 2012 by RichardAdams

Title

Get information from another field but not making it dependent

Post

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!

Outcomes