This one arises strictly due to many years programming in FMP where the issue just doesn’t come up.
I’m a bit puzzled by the dynamics of multiple keys in a single relationship. Must ALL keys be matched to satisfy the relationship, or will there be a match if ANY key pair matches? Again, what strategic advantages are there for multiple keys?
Pages 85 and following of the User manual doesn’t explore this issue. Is it covered elsewhere?
Morley:
This one arises strictly due to many years programming in FMP where the issue just doesn’t come up.I’m a bit puzzled by the dynamics of multiple keys in a single relationship. Must ALL keys be matched to satisfy the relationship, or will there be a match if ANY key pair matches? Again, what strategic advantages are there for multiple keys?
Pages 85 and following of the User manual doesn’t explore this issue. Is it covered elsewhere?
Yes every key has to match. That’s how relations work in Filemaker too.
so if you use:
contactid = contactid
amount =< amount2
you will only see the related records that:
match the contactid’s
and the amount must be eaqual or smaller than amount2