Sorting Fields???

[mKirk]

Let me see if I can explain my latest difficulity. Say you have 10 fields...with 3 of them containing data and the rest empty, like:

field01= ""

field02= 2

field03= ""

field04= ""

field05= 5

field06= ""

field07= ""

field08= ""

field09= 9

field10= ""

What I'd like to do is write a button script that "moves up" the 3 fields which have data (in numeric order) to end up with:

field01= 2

field02= 5

field03= 9

field04= ""

field05= ""

field06= ""

field07= ""

field08= ""

field09= ""

field10= ""

I'm not sure if this is some sort of sort function or something else which is as yet unknown to me. As usual, thanks in advance for any assistance.

Edited August 14, 2005 by Guest

[comment]

The way this is usually done in Filemaker - and in databases in general - is to put the data in related records. That way there are no empty slots, since you only create a record when you have some data to put into it. When you delete a record, you also delete the unused data slot.