I have a set of records (shown in a portal)each record has a field called "selected" which can be toggled to show "Y" or "N"

I want to populate a global text field with just the the selected records so I use a created a another table occurance called selected records and jioned them via the selected field.

I can now use the List Function to populate the text field from this selected table occurence.

HOWEVER..

I need the text field to show records in the order I click them not in order of the selected records table. Changing the sort order of the selected table does not change the order the list function populates the text field and I do not know how to proceed. So any help or ideas on a different method would be really appreciated.

I think you would either need to use a calc field that concatenates your field and whatever determines it's order, then List() that (and sort it and parse it later, probably using CFs), or use a looping method to build the list. It's probably simpler to use a looping method.

A couple of thoughts. Your Yes/No flag field should be a calculation. In a multi-user environment, you wouldn't want to mark the record as selected (every will get everyone else's selections).

So, the checkbox is really a button that puts the recordID in a global text field in the parent table. The flag field in the child is a calc, if patterncount (globaltext, myrecordid, 1, 0). Also, you'll need to clear them from the global text when they are deselected. I use Matt P's CF AddRemove

You use a relationship from the global text field to gtrr.

I think that the global text will have the values in the order that they were clicked.