From the course: Learning FileMaker 16

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Constraining or extending found sets

Constraining or extending found sets - FileMaker Pro Tutorial

From the course: Learning FileMaker 16

Start my 1-month free trial

Constraining or extending found sets

- [Instructor] A lot of times when you're searching for data inside your FileMaker custom apps, you're going to create found sets but than you might think of another criteria that you want to affect against the existing found set, either constraining it further or extending it out. So, in those cases which involve additional steps, there are tools inside FileMaker that'll help you do that. And this can help when you're doing some data mining or troubleshooting within large data sets. Let me show you an example. Let's say I go into find mode and I go into my status field and I'm going to type inactive, it gives me a found set of 147 records. But now what I'm going to do is go back into find mode and enter the criteria of California and instead of hitting a perform find, I'm going to go into the request menu and choose extend found set. Now you see I have 166 records and not all of them are inactive. That's because what I've done is I've added the entire found set of California records…

Contents