Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Finding records that match criteria from found set


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

Recommended Posts

  • Newbies
Posted (edited)

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 by Guest
Posted

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

Posted

LOL Soren,

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

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

Posted

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 :P-)

This topic is 6369 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
×
×
  • Create New...

Important Information

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