This was an interesting request from one of my user's, and I couldn't really give him an answer. For some reason, I thought I heard of this capability somewhere.

So I decided, why not try asking the brilliant minds that inhabit this Forum.

Lets say your database has tons and tons of records, and lots of information in each record.

The boss wants his minions only working on a specific set of those records.

So lets say, the boss filter's, constrains, searches, and gets all of the records down to a small few, and wants his team to work on only that Found set.

Is there a way to share the found set via an email link or something so that, when the user receives it, they can view only the found set, without having to worry about the filtering, constraining, etc....

I understand, it could be scripted, and tied to a button... but I am thinking it will occur pretty often, and I would hate to make scripts for each one.

Any ideas?

You can store this in a collection table. Basically it would store the name of the collection, and the IDs in a multi-line in a text field. Then to load that collection, you can just use a Go to Related Records keyed from this field ( or you can set a global if you want to ) to the table with the orig records.

Dont forget to have a primary key for this new table too.