Go to a list of records problem

[sandyinlet]

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.

[Drew Sanderson]

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.

[sandyinlet]

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

[Drew Sanderson]

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