4 Replies Latest reply on Sep 6, 2012 10:05 AM by RichardAdams

    Get information from another field but not making it dependent

    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!