In filemaker you can use multiple keys for portals by entering hard returns between the keys in your keyfield. Is there a similar way in servoy?
in Servoy you usually map several different keys. There is no need to calculate keys that contain several values, instead you use key <=<= key… Have a look at the definition of relationships.
patrick:
in Servoy you usually map several different keys.
I think that this is different from a multi line key though.
In FMP, a multi line key and a relationship with multiple predicates behave quite differently.
I think what you are talking about Patrick, is basically the same as a multi predicate relationship in FM7 (what we used to do with compound keys in pre FM7). Each predicate must match in order for a related record to be returned. In addition, the keys involved are defined at design time. This type of relationship can be used to return matching records that fall within a range, but not non-contiguous values. (AFAIK)
In a multi line key, if any values match, related records are returned. Either side of the relationship can use multi line keys.
So, I think the question (if I may) was, does Servoy behave the same way when using carriage return delimited text keys in relationships? If not, is there some other way, at the level of the relationship, to create multi line keys, with this effect of ‘or’ matching in relationships?
Ok. If the question was about the ability to use those keys for “OR-relations”, then I suggest to use SQL queries for that. That’s at least what I do.
the thing you describe is really a N-M relation. That is how it supposed to be done on a sql database.
tablex
nmtable
tabley
and in the nmtable you have
tablexid1,tabley1
tablexid1,tabley2
ect