Jump to content

Finding subsets within a find and then returning b

Chef Roy

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

Recommended Posts

As a Newbie I have tried finding similar scenarios in these forums to no avail so here goes...

I have a database of chefs with different membership levels. The user searches on a specific membership level which may produce 40 out of 900 records.

The user goes to the reports area of which there are several reporting options associated with the records found. Displaying all the records in any standard reporting layout is easy, it's the searching of other data within those found records is the kicker yet still maintaining access to the original found set.

Example: Finding records within the found set that have stale addresses. Easy to find the stale addresses using a SET FIELD and Find Constrained BUT! how the heck does one get back to the original found set of records so that the user can perform other related reports?

Would really appreciate someone's help on this.

FileMaker Version: Dev 6

Platform: Windows XP

Link to comment
Share on other sites

You can add requests to find/omit records within searches. Do your original search then add a request to exclude all records except those you're interested in. Then use 'show omitted' to get back to your original set. You can use multiple requests within one search.

Or you could create a text field 'mark'. Create script using 'Replace' from the Records menu which inserts "Y" into found records. Create script 'find marked' which searches for "Y" in 'mark'. When finished with other constrained sets, run script 'find marked' and you're back to you're original found set. You should include 'unmark' script - otherwise new seaches will find previously 'marked' records.(Create global text field, insert text "Records marked" as part of 'mark' script to alert you that records are marked, clear field in 'unmark'.) You can create a button as a mark/unmark toggle.

Link to comment
Share on other sites

This topic is 6496 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.