FM and "OR" relationships!

[presley]

Hi,

My apologies in advance for the semi-stupid question.

I am confused by FM implementation of "key" relationships. There does not seem to be a way in the relationship graph to create an "OR" relationship. For example: If I create a "many to many" relationship from a social security key and would like to find a related record on social security OR last name ...there does not seem to be a way to do that in the relationship graph.

Am I missing something? ..is there a way to "trick" FM into doing OR relationships?...do I have to script this functionality?

Thanks in Advanced

[mr_vodka]

See if this helps.

Taken from the FileMaker 8.5 Help section:

You can increase the number of possible matching values by entering multiple values in the match field, separated by carriage returns. You can access related data by matching any single line of your match field, according to your relationship criteria. This is sometimes called a multi-key field or complex key field.

For example, you have a simple relationship joining records in TableA to TableB based on the contents of a single field in each table, and the match field in TableA contains the values:

red

green

blue

separated by carriage returns. FileMaker Pro will match any record in TableB where the corresponding match field contains the single value red, green, or blue. However, FileMaker Pro will not return records where the match field contains the value red green blue. The carriage returns tell FileMaker Pro to treat each line as a separate value.