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))