hai… i create a new table
one of the field is related to table item ledger entry
named field Item Serial No.
so i want to use table relation
so I add in properties table relation like this
“Item Ledger Entry”.“Serial No.” WHERE (Serial No.=FILTER(<>’’))
→ I hope records that will show only with serial no
but it still shows every records with or without serial no.
do you have any idea why this is happened?
For your information
the primary key for item ledger entry table is Entry No. And Serial No.