How can I have hierarchy in the two seperate filters for a report.. for eg. company and branch filters are coming from the same column Org_code of Organization table.
How can I make branch filter dependant on company filter we distinguish the them by the lookup to another column organization type which is having tags like company and branch
My table structure is like:
Org_code organization type Parent Org
ABC Company -
CDE Branch ABC
EFG Company -
HIJ Branch EFG
I want to have a list box to filter company another list box to filter branch which is depandant on the company and by selecting the branch rest of the data would be displayed.
can anyone please help me with this..