Use one or more custom field(s) to populate another

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
Age1 Adult
Age2 Senior
Age3 Student
Age4 Junior
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.
Kind regards
David
 

Hi David

Afraid of this is complicated and not possible to implement

Regards,

Tuan

Hi Tuan,
I thought that might be the situation.....not a problem, we will continue with what we have at the moment.
Kind regards
David