Sorting records

[lamBRETTa]

Not sure if i am in the right area or not, but since i am building my dbase with Developer 7 this is a good place to start, yeah?

I have a field that is formatted as a checkbox set and uses a value list with 1 custom value - 'yes'.

I created a sort script so all the checked records would be grouped together.

The problem is when you sort the records, some records where the box is NOT checked pop up in between the checked ones.

Any ideas?

Thanks in advance.

[Lee Smith]

You need to place a copy of the field [color:"blue"] without checkboxes on a layout and sort it instead.

HTH

lee

[lamBRETTa]

Aha...your tip helped me realize what the problem actually was.

After placing a copy of the field on the same layout and changing

it to an edit box, I noticed that the records that were NOT checked and were

showing up inbetween checked records had a different value than the checkbox.

So they were being factored into the sort.

Problem solved!

Thanks for the advice.