Conditional Get field and sort records problem

[1616]

Two questions i need help on

1)I think i need a case statement but im not sure.

I have a checkbox called Names a field called current name and a field called no of players.

No of players uses the count feature to count the number of checked items.

Currently the field current name hold the first checkbox item GetValue(Name;1).

I need a script that will enter the checked name equal to the no of players field.

eg

If No of Players =3 the field current name will show the item that was checked 3rd)

2) I have a field called records needed, is there anyway that i can sort records based on the number in this field; in the following format.

If Records needed= 15 the first 15 records will be sorted

Edited June 8, 2006 by Guest

[LFO Staff Member]

For the first question, if you replace the GetValue (Name; 1) with GetValue(Name; No of Players). This should give you the 3rd value in the Name list if you have 3 things check off. Is this what you mean?

[1616]

Not exactly what i was looking for, but its done what i needed it do another way, thanks very much.