Multikey Syntax

[dante_in_calgary]

Folks

Firstly, thank you to all who contribute here. It's a great resource.

 

Here's my current dilemma. It seems simple enough.

 

Table 1

zConstant = "Football"

 

Table 2

SportType (shown by value list of "Football", "Baseball", "Soccer", "Hockey")

 

Initially I had the relationship set up as SportType = zConstant. All works well.

 

However,

 

Now I realize that I need to have the relationship to work for both "Football" OR "Hockey".

 

I can't seem to understand how to create the *OR* relationship. I can only find *AND*

 

Any help is most appreciated.

[Ender]

FileMaker uses values separated by line returns to make OR relationships. In your case, change the constant's value to "Football¶Hockey"

[dante_in_calgary]

Perfect. Thanks for your help on this.