FM14 Join table oddity

Discussion created by DavidZakary on Jun 1, 2015
Latest reply on Jun 1, 2015 by keywords

I've built a join table for a registration system. All works fine to start. Records are added via a portal with a popup menu/value list on a field to populate the key value and then the name is displayed via an overlaid field..


There is no sorting on the portal nor on any of the relationships associated with it.


I need to grab a list of all of the names and the key values or later processing. I put them into global variables. Again, no sorting of any data. The lists are generated via Set Variable and the List function.


The list of names that I see in the data viewer is in a different order than what is being displayed in the portal. The list displayed in the data viewer IS being sorted for some reason (by last name). Everything is being pulled via the correct relationships. I'm quite baffled by this.


And it is important that the names are processed in the same order that they were added to the join table.


Any suggestions as to where to look? I've run out of ideas and soon hair.