AnsweredAssumed Answered

Sorting Records with a button

Question asked by Terri on Apr 8, 2010
Latest reply on Apr 8, 2010 by philmodjunk

Title

Sorting Records with a button

Post

Hi,

I am using FMP 9

 

I currently have a database that has 30 records. Record 1, record 2, record 3.....record 30.

 

Each of these records has 5 fields - Record Number, Record Name, Date, Price, Age.

 

My layout is in column form.

 

This is an example of what I want to happen:

 

Change Record 5 to Record 1 and Record 1 to Record 5. Only change the record number but keep all the corresponding info. Then....sort the records so that the new Record 1 (formally record 5) is now the first record (in other words, the records fall back into order but the info for the records that I have renumbered stay with its corresponding record).

 

Any way? Any one?

 

I have tried to make my explanation as simplistic as I can. Hopefully not too much.

 

 

Outcomes