Table relation Question

uri84

Hi all, i want to make a question to see if anybody can help me.I have this table relation in Nav2013 r2:

IF (Resource No=FILTER(<>'')) "Job Task"."Job Task No."
WHERE (Job No.=FIELD(Job No.),
Status=FILTER(<>Finalized&<>Rejected),
Resource No.=FIELD(Resource No))

It Works Perfectly but i have a question, i want to know if its possible to say in Resource No Field that i want to filter by Resource No, and when resource no value is ''. is it possible??

What i want is something like this...
Resource No.=FIELD(Resource No)) OR Resource No.=FIELD(Resource No = ''))

This is in the property of tablerelation.

Thanks!

vremeni4

Hi,

If I understand the question correctly you want to show all records with the same "Resource No." plus all records with blank "Resource No."

I think this is not possible as "OR" option is not supported in the table relation property for Type "FIELD".
If you use FIELD, then you cannot use FILTER and another way around.
Resource No.=FIELD(Resource No)) OR Resource No.=FIELD(Resource No = ''))

The only way around is to write a code on the Lookup trigger that would have the same effect. You could use a query object to achieve this.

thegunzo

Perhaps by adding a FlowFilter field that will have

SETFILTER("Resource No. Filter",'%1|%2',"Resource No.",'')

and use the table relation to the flowfilter ???