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.

Regards

Nabin Kumar Sinha

 

  • I resolved the issue.

    correct solution is.

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

    Thanks 

    Regards

    Nabin Kumar Sinha

     

Related