Hi,
Please excuse the semi-stupid question in advance!

Is there a way in the FM relationship graph to create an "OR"
relationship. For example: I have created a
many-to-many relationship using social security numbers between 2
tables. I would like to do a find on the social security number OR last
name in the related field. There does not seem to be a way (in the
relationship graph) to do that in FM.

- Am I missing something in the relationship graph?
- Just can't do that in FM"
- Can do --but you have to write a script?
- You are a dummy ---give it up ...



Thanks in advance!

presley2 (AT) comcast (DOT) net <presley2 (AT) comcast (DOT) net> wrote:

I haven't found one either. I'd try two seperate relations, one for each
field, so could create two separate portals or value lists or whatever.
--
http://clk.ch

In article <1166463536.075418.158170 (AT) 79g2000cws (DOT) googlegroups.com>,
"presley2 (AT) comcast (DOT) net" <presley2 (AT) comcast (DOT) net> wrote:

Filemaker allows multi-key relationships. This is normally done by using
a text field as the key field, and having several text values, separated
by carriage returns, in the field. Then the relationship is made
whenever the related key field contains a value that matches one of the
values in the multi-key field.

You could have the contents of the multi-key field set by calculation,
or could perhaps use a calculation field with the result displayed as
text. That way you could cause the multi-key values to be Social
Security Number and last name, separated by a carriage return ("pipe"
character in the formula)

--
For email, change <fake> to <earthlink>
Bill Collins

Provided both fields are textfieldS, or you can translate both values to
text.

Create a calcfield cMyCalc, result as text. RETURN is the return symbol.
getastext (SocialSecurityNumber) & "RETURN" & name

Use this for your relation. When you now type the number OR the name it will
return the related info.
Be aware that there might be more then one user with the same name. So
setting this up with a portal and then GTRR with a script might come in
handy.

Ursus


<presley2 (AT) comcast (DOT) net> schreef in bericht
news:1166463536.075418.158170 (AT) 79g2000cws (DOT) googlegroups.com...