Looking for advice on how to move records in a portal that would be as easy as moving line items in script writing. That is to say, hold down mouse, then move the item up or down on the list. I am hoping that this would allow me to reprioritize the list of items.

Thanks

Topic moved here...

It would not be easy... my only suggestion would be to sort the portal on a seperate field, the contents of the field are replaced to vary the position. Little up/down buttons on the portal rows change the sort value the replace the whole set of records to reorder them.

I got stared on a system like this (but not in a portal) as an exercise and it sort-of worked, the only problem was that after resorting the current record was lost and the user went back to the top first record. This problem could be overcome, but that was where I stopped.

Using Filemaker Pro 5 by Coulmbre & Price details exactly how to do this (I highly reccomend this book!).

Basically, you tell the relationship defining the portal to sort on a field called "sort_order" then you make up and down arrows swap numbers with the "sort_order" value of the portal row it is trading places with.

Obviously more complicated than that but you can figure it out or buy the book.

[This message has been edited by signal (edited February 24, 2001).]