PLEASE IGNORE THIS... it does not work...
If you stored the favourites in a field or calculated that field with a checkbox for the Company that marked them as "Favourite", you could have the valuelist sort according to the field. This would put the Favourites at the top of the list and place others undernearth (probably with Alphaumeric sorting).
I have never tried this with a divider... but it would probably work if you added it as a literal at the end of the calculated field.
Message was edited by: Lyndsay Howarth PLEASE IGNORE THIS... it does not work...
I am not quite sure what you mean myself.
Having just gone to the solution to check my logic i must now very humbly say that I was wrong!
I'm not sure where my brain was but I had just returned from the dentist...
I'll edit it so people know not to pay attention...
I don't believe the accounts can reside in the same value list (although I can be wrong). But how about two value lists such as the attached? You will need to sign into Tech Net to see and download the example file. In the attached, the favorite value list is hidden under the button and grouped. I use Go To Object [ dummy ] to remove the cursor from the field (without committing the record) after selection.
You might be able to stack (favorites on bottom of stack) and pop the favorites first then use triggers to either move to the next 'all' version or exit. This all would depend upon whether you use pop-up or drop-down, whether Mac or Windows, and which FM version.
Maybe this will at least get some additional ideas going. :^)
Message was edited by: LaRetta: UPDATE: Corrected file name (blush) and attached the script trigger to remove the cursor from the favorites field.
FavoriteAccounts.zip 7.6 K
Just a quick reply and apologies if I misunderstand the question:
If you are designating the Favorites by having the User click on the layout -
You can add a number field for that table/relationship (for the value list) to sort by.
That same click can populate (set) this field with the next sequential number (serial number option).
Then sort the value list relationship by that field in descending order. This would place the most recently added Favorites at the top.
I like this. I was about to suggest poping up a window with a portal or a list view, but this is much simpler to implement and quite workable.
You might be able to stack (favorites on bottom of stack) and pop the favorites first
You could also use a modifier key to select the value list, e.g. click for favorites, option-click for the full list.
1 of 1 people found this helpful
I replaced the file because I had mistyped 'favorite' and I just couldn't leave it, LOL, and I had not attached the trigger to leave the field. It looks a bit better now when you make the selection.
Thank you all ! Going to test the options
Yes... well done...
Although from our point of view you still spelt 'favourite' wrong... ;-)
That's a point...
If the valuelist sorts by the second field which is a number... but of course the number has to be unique and populated into every record or the dups won't show.
If that number field was calculated from 2 fields... one as an auto-entered decimal serial and the other which auto-enters say "10" in it... which for the favourites you change it to a "1"... then when it is sorted it would look like this:
... then it does work... just ugly.
Message was edited by: Lyndsay Howarth