Table Filter

Dear Sir

we created two field 

1. Bank Code-TableRelation -"Bank Account".No.

2.Cheque No.-TableRelation - "Check Ledger Entry"."Check No.

We want when users select Bank Account No say "BNK001" then only BNK001 related cheque should be display when user select cheque no.

I  tried but it is not displaying.

"Check Ledger Entry"."Check No." WHERE (Bank Account No.=FILTER(NO.)) where I am wrong??

Please advice me how to resolve the issue.


Nabin Kumar Sinha