Good day, how can i achieve filtering the ref...

(Jessrhyl Longay) #1

Good day, how can i achieve filtering the ref column in other forms that it is used?

(Levent KULAÇOĞLU) #2

@Jessrhyl_Longay

In your ref column’s Valid_if you can use a SELECT expression:

SELECT(TableName[KeyColumnName],NOT(IN([LookupColumn],TableName[KeyColumnName])))

(Aleksi Alkio) #3

And in generally… SELECT(TableName[KeyColumnName],YourOwnEvaluation)

(Jessrhyl Longay) #4

@Levent_KULACOGLU this was what i did. thanks