From the course: FileMaker Pro 15 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Constrain or extend found sets - FileMaker Pro Tutorial
From the course: FileMaker Pro 15 Essential Training
Constrain or extend found sets
- [Voiceover] I'd like to introduce you to a search technique that seems like it might be similar to something that we've already done in this chapter, but it's different that doing an inclusive search using two or more requests. There may be times when you want to add or remove from your current found set as opposed to searching within the entire database of records. So in these cases, you will use functions that are called constraining and extending found sets. So for example, let's say I want to do a search by entering find mode and then entering California into the state. I hit perform, and I get 23 records. Now, I'm going to go back into find mode, and this time I'm going to type in inactive in the status field. Now if I go ahead and hit enter, what I'm going to get back are just any records, 147 of them, that have inactive in the status field. It has nothing to do with the state field that I searched for earlier. But what if what I intended to do is find only inactive within the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.