<div>
Hi Will, this works perfectly particularly so as method compatible with the legacy data imported, very much appreciated...
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have a list of projects in a single table each of which has a UID serial number field and separate numerical sort order field. <br />
<br />
Wondering if there is a way to display the list in a layout or portal and allow user to select any item in the list, &nbsp;and move it up or down the list order, &nbsp;updating the 'sort order' &nbsp;field with its new position. &nbsp; <br />
<br />
The purpose is to be able to create custom sort order for report layout. <br />
<br />
Any pointers much appreciated..
</div>
</div>


Hi, 

I have a list of projects in a single table each of which has a UID serial number field and separate numerical sort order field. 

Wondering if there is a way to display the list in a layout or portal and allow user to select any item in the list,  and move it up or down the list order,  updating the 'sort order'  field with its new position.   

The purpose is to be able to create custom sort order for report layout. 

Any pointers much appreciated..

Filemaker record reorder popup

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.