TableRelation Property - Problem With Condition

gpdiat

Hi, i have a table that contains two fields among others, one Boolean (A) and one of type Code(B).

I want to put a TableRelation to field B so that if A=yes then TableRelation=Customer.No else TableRelation=Vendor.No
Though this works on 2009, it doesnt work in 2013 R2.

TableRelation Property of B
IF (A=CONST(No)) Customer.No. ELSE IF (A=CONST(Yes)) Vendor.No.

When i run the page of the table, i put a filter (A=yes) to the page.
Then i want to put a second one for field B. It should automatically choose to show me Customers but it shows nothing.
The same goes for filter A=no.

I would be grateful for any help you can provide me.

thegunzo

did you try

IF (A=FILTER(No)) Customer.No. ELSE IF (A=FILTER(Yes)) Vendor.No.

I am not sure that you can build relations on a flowfilter.