TableRelation in Text Box - How do i set a WHERE clause

Jza

Hi Guys,

Trying to use a WHERE clause in a tablerelation in a text box. I have seen one where someone had entered what was in effect a SELECT statement. But i can't find how to syntax it properly.

The text box currently displays all of the Purchasers from our SalesPerson/Purchaser table. I have since added a flag ("AllowFlag") to the table. I want to filter all the Purchasers who have the "AllowedFlag" as TRUE.

Anyone know how i'd set this.

I want it to display the following if you follow:

SELECT Purchaser FROM SalesPerson/Purchaser WHERE AllowedFlag = TRUE

Anyone have any idea how i do this?

Jza

Waldo

Something like this?

WHERE (AllowedFlag=CONST(Yes))

Jza

Thanks will give that a try

Jza