Simple Question - I think

[Snow-i]

I have a value list pointing to a join table which I've created a many to many relationship for. In my master layout I have a portal with Pop-up menu for the selection of records and the associated value list. Everything is working correctly, except that my user wants the list that pops up to have a custom order. How can I make the pop-up list use a custom order as opposed to automatically being alphabetical?

Thanks in advance!!!

[bcooney]

You might want to look at this for maximum flexibility:

http://fmforums.com/forum/showpost.php?post/365428/

This list view in the select window can be sorted by turning column headers into buttons that sort.

[Snow-i]

bcooney,

Thanks very much, but i'm not sure that solution will work. The "list" (child table) has over 150 records. I'm wondering if sorting by the serial number wouldn't be a bad idea, since the list will be seldom modified but constantly used. I realize the design problem with this solution, but my user is adamant that the list be in a particular order prescribed by him and likes the pop up menu system.

If you hadn't already noticed, this is the same issue that you helped me with in the relationships forum. I had a basic join table question.

http://fmforums.com/forum/showtopic.php?tid/217356/

This is the portal for that very join table for "interest codes." The attached is what it looks like. I have two portals to two (join) child tables that do the exact same thing - they're just different lists. Only the "interest codes" need to be custom ordered. The list that I have popped up there can remain alphabetized.

Thanks in advance!

[Snow-i]

Oh, and excuse the apparent god-awful coloring :-). I have color codes for fields that might be moving around a little bit as he decides what information he needs to keep and what to toss out - we're moving from an old 16 bit database program called trackmaster plus.

[bcooney]

If your Interest Codes table has a SortOrder field, then you can lookup this value when you add an Interest Code to the join table. Sort the portal by this SortOrder_lu field.

Also see comment's portal sort demo: http://fmforums.com/forum/showpost.php?post/294075/