Jump to content

FM and "OR" relationships!


presley
 Share

This topic is 5771 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5771 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.