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

I resolved the issue.

correct solution is.

“Check Ledger Entry”.“Check No.” WHERE (Bank Account No.=FIELD(Bank Code))



Nabin Kumar Sinha