I've got a membership database with different countries and groups. So I've setup 2 objects one for countries one for groups and then connected them to a members object which holds all the info on each individual member.
But is there a way that I can restrict the groups shown to the country chosen. So for example when a Australian admin role adds/edits a member they only get to choose from the groups in Australia, then for a different country same thing that admin only sees the appropriate choices for that countries groups.
Presume I would start by making those country and group fields multiple choice but then I'm not sure where to go from there?
thanks Jonathan