I have created three (3) more levels for a data entry form after period namely:
1)Module
2)Sub Recipient
- Sub-Sub Recipient
So the data entry person must specify the module s/he is reporting for.S/he should also specify the Sub recipient of the grand and then lastly the sub-sub recipient of the grants.
My question is,how do i configure so that when one selects the module of their project,the sub recipients should filter to only show the list of sub recipients who are carrying such a module.Then when i select the sub recipient,the sub sub recipient dimension should also limit according to the sub sub recipient attached to the Sub recipient.
Thank you
Stanley