My client wants to click on records to indicate choices, in effect to build a random list. Then click a button to display that list. My thought was to use a global field to store his list of serial numbers separated by a carriage return, then do a Go to Related Record based on a self relationship to that global. Both the serial number and global field are text fields. This works when the global has just a single serial number, but not for a selection.

Much appreciated.

Attach a sample file so we can see where you are at and then can edit it and post it back with a solution. It will make it all much more clear.

Attach a sample file so we can see where you are at and then can edit it and post it back with a solution. It will make it all much more clear.

I've attached the sample. However, the problem is solved in the sample. Somewhere in my client's file there's a mismatch to the technique demonstrated in the sample.

Thanks for the help.

ListProblem.fp7.zip

Sample files are great for helping to check your logic and eliminate issues of the larger solution. Glad you are up and running!