Filteration in Lookup based on detail
I am working on a scenario, when a user changes the value in account field in activities section a custom lookup ( say bank account no.) needs to be filtered based on a detail inside account section. This detail in account section has two lookups ( account and bank account no. ). But the custom lookup in the activities section has only the bank account no. in it.
As there is no direct relation between the two tables, I am not able to use simple filteration rule. Is there any way to get this sorted?