Storing User-level Found Sets (not find criteria)

[danabase]

I am looking for suggestions for creating a way for Users can “mark” records and save those groupings over time. I have a client who wants to be able to mark groups of records, and add individual records in easily retrievable found sets. Sort of like the way FMP 10 can save finds, but this would be more similar to saving found sets, and updating them. Currently they have simple checkboxes to mark records which they check and then clear, as needed. They have to let the office know when they are using the mark records checks and can only have one User marking records at a time. They have 4 such checkboxes, but in reality, they would like each User to be able to mark up to 10 different sets of records and to not have to worry about someone else modifying there marked records.

If anyone has something I could look at – great – or if there are suggestions, let me know. I have searched the forums and did not quite find what I was looking for. Thanks!

[Fitch]

Rather than marking the records, create a table for storing them. The fields in this table would include:

User ID

Found Set Name

Date etc.

and most important, a text field for storing the IDs of the found set.

Store the IDs in a return-separated list, and you can set up a relationship from that field to the original table. Voila, unlimited found sets for every user.

[bcooney]

This may help: http://fmforums.com/forum/showpost.php?post/293833/

[Fitch]

Thanks for sharing that example. Since "they would like each User to be able to mark up to 10 different sets of records," my suggestion was just taking it one step further: a table dedicated to storing the finds, which would in turn be linked to a User table.