select random records from a find

[Stephen S]

Our company tracks TV programs. Each record has information like show name; producer; distributor; assessment notes. There are created date and modified date fields. Sometimes we only have show names to start with and only pass this show information on to clients when all the information is complete (exported to a PDF as they don't use FileMaker). There are hundreds of shows and I want to be able to select them based on 2 found sets. 1. the most recently created AND the most recently modified. (I have no problem doing this.) 2. Manually de-selecting some records from this set (this is my problem). I created a single check box for each record (which I did using a single box from a value list) then did a new find for just those records that were checked, till I realised that this changes the modication date for future searches.

[Raybaudi]

and ... ?

Which is the question ?

[Stephen S]

Sorry I wasn't clear.

My question is how to manually de-select or select some records from a found set. For example like choosing random items from a shopping list.

[comment]

I got confused by your use of the term 'random', which has a very specific meaning in Filemaker (and in computing in general). Choosing random items is NOT the same as choosing items at random.

Anyway, I believe this should answer your question. Note that all these commands can be assigned to buttons as individual steps or included in a script.

[Stephen S]

Thanks comment. I've had the honor of seeing your work in these forums.Your solution was perfect. I kept thinking it was a complicated solution when it was a tool already built into FM menus.