The only person who should modify the records showing is the user himself.Īs covered in the first article in this series, Preserving Found Sets, temporarily saving a found set can be easily overcome with the New Window feature. If you have to change the found set, current record or sort order, you had better restore it. The user doesn't care how difficult it is to program a feature. Maybe the user is running a script that does something very complex that requires destroying one of these elements. Sometimes you have to break the found set, current record or sort order, unbeknownst to the user. The found set, along with the current record and the sort order, determine the look and feel of a database for a user. Practically all features in FileMaker are structured by the found set.

Found sets determine which records print, sort, export and preview. Without found sets, a database wouldn't be much more than a relational spreadsheet.

I'm not saying it's anywhere close to the impact of the Apple Super Bowl commercial but it's fun to have a look.įound sets are what make a database a database. It was one of those favor things so it only played once. This is sometimes faster than using the toggle control in the lower left corner of the window.īeginner, Intermediate and Advanced Video TrainingĬlaris Commercial Few people know that Claris produced a commercial and it aired on national television. Toggling Parts While in layout mode, clicking on a Part with the Control key (Windows) or Command/Apple key (Macintosh) held down will toggle between their vertical and horizontal positions. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service. Over programming hurdles via GoToMeeting. Meta-consulting is a service Database Pros offers to help other developers Support this site by clicking on a sponsor below or becoming a patron! The Philosophy of FileMaker - Saving a Found Set

Merging filemaker pro 14 join table