70
i need to make tablerelation on the Item No. so that i can pick item but the filter must be if empty or have a value like the header variable but how do i make this?
i'm trying to do something like this: tableRelation =item where(reservedbycus=const(' '),reservedbycus=(field(cusno));
it's returning empty list .
I stumbled over a similar problem, but as Rehan Satti wrote, you need to use the |.
In my case it was by using two filter values for the same enum:
TableRelation = "Price List Header" where("Price Type" = filter(Sale), "Source Group" = filter(Customer), Status = filter(Active), "Amount Type" = filter(Price | Any));
You can do some think like this I am linking a custom shipto code field to standard table ship to codes
I think you need to find workaround in your logic.
You have to use Or '|' between your filter.
tableRelation =item where(reservedbycus=const(' ') | reservedbycus=(field(cusno));
I am not sure what would be axect filters regarding your condition, However follow the link
#1
Sohail Ahmed
1,452
#2
YUN ZHU
1,313
Super User 2025 Season 1
#3
Gerardo RenterÃa Ga...
1,083
Most Valuable Professional
Share
Report
All responses (
Answers (
