Or Condiditon for Relation

[oleung]

Hi

 

I would like to see if someone can advise how to the set up OR condition in the relationships setup in the Manage Database dialogue, which seems only allow "and" below setup.

 

How can we handle "OR" case .

 

For example, I want to show records in the portal with company = "ABC" or company = "BBC" etc.

 

Thanks,

[Ender]

For an OR relationship, you'll need to append the values into a single, return separated field, and use that field as the key. So a field with the value:

 

"ABC¶BBC"

 

would match related records with either value.

 

Such a field can be calculated, or populated with a script. It just depends on the situation.