I am trying to allow the user to enter a unique record ID, have FileMaker Pro find that record then find all the records that have values matching some of the fields of that record. How could I accomplish this?

Edited June 16, 200718 yr by Guest

Beyond that your header says something different, make a new calc'field of text format:

List ( Field1;Field2;Field3;Field4;Field5 )

...and make it a keyfield for a selfjoin relation, and follow the "Perform Find[]“ by a GTRR(SO) using this SJ relation. Since the found set of a search in unique ID's yeilds just one record, but the the GTRR(SO) make's a set of more.. provided it's contents have other records matching.

--sd

Huh? Thank you for replying to my post, but that went over my head. :P

LOL Soren,

Did you see that they had novice next to their name?

Evan could you post a sample file of what you're trying to do?

Søren's advice is actually the easiest, using the latest and greatest of 8.5. It just doesn't sound simple to beginner.

The List() function in this case is just a simple way to get the multiple fields specified into a return-separated list. You could also write it (pre 8.5) as:

Field1 & ¶ & field2 & ¶ & field3... etc.

Then make a self-relationship, using the above for both sides. "Find" the records that match ANY of the field values of the current record by using:

Go To Related Record [ above self-relationship name; show only related records; match current record only ]

Because List() produces a multi-line result (when given more than 1 local field, or one or more related fields), you are matching ANY of the values to ANY of the values. Which, by the way, would match "Fenton" as a first name to "Fenton" as a last name. If it is important not to match across fields, then a different "gathering" method is needed.

One really needs to know what List() and Go To Related Record do, as they're often the guts of relational operations; and fairly simple to use.

(P.S. I have an auto-typer that expands GTRR to Go To Related Record; otherwise I'd never be able to answer so many questions -)