Currently we have 4 categories of membership
Adult age 17-59
Senior age 60+
Student age 17-25
Junior age 12-16
So we have 4 custom fields for each category
Each one has number range that the user can select from i.e. Adult min is 17 max is 59 Senior is 60-99 etc.
This all works well but when we display our members lists there are 4 different age columns for each member with only the relevant one filled in
What would be nice is if we could map depending on the category the 4 different age fields in to a separate 1 which we use to display in the members' list So we map Age1-Age4 into say AGE and then just display AGE in the members list rather than the 4 separate ones.
I don't think it is possible to map one custom field to another, but I thought I would ask the question.