Unanswered: Selecting Subgroup based on specific Group
I have a Lookup table with a Group and Subgroup field.
I have created a range for the Division and also for the Group.
On my main page, I have created a list option which allows the user to select the items under Division
What I want next to do is based on the primary selection for Division ; I want it to filter it on the specific Subgroup.
The User selects "Specialist Services" from Division, the Subgroup will subsequently only show the appropriate selection which is Dental Hosp, Rehab Services, Learning Disability Services and no further selection.