Seeking a navigation system among 200 individual / card DB for attendance at camp

[Bob Sneidar]

Assuming the second word IS the last name, 

sort index1 by word 2 of each

or

sort index1 by last word of each

which will allow you to have middle names. The caveat to this approach is that people who have multiple words in their last name will have to be entered without spaces. Sometimes people get really picky about that. So Betty Jane Smith Ross would have to become Betty Jane Smith-Ross and who cares if she doesn't like it like that! :-)

Bob


On Jun 13, 2012, at 2:23 PM, Mark Rauterkus wrote:

> Hi,
> 
> Now to sorting the results of the navigation field.
> 
> 
> Working:
> 
> sort index1
> 
> Perfect, except, and the names come back in the results posted as
> expected by the person's First_Name Last_Name.
> 
> But, how does one sort so that the Second_Name is in A-Z order?
> 
> My broken attempt:
> 
> sort second word of index1
> 
> And, I guess index1 is just a temp container and not an array. Right?
> 
> 
> --
> Ta.
> 
> 
> Mark Rauterkus       Mark.Rauterkus at gmail.com
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode