sort list by invisible field

[macavity]

Hello. I think this isn't possible, but asking anyway:

I want to sort a value list by a field without the values in that field appearing in the value list itself.

For layout reasons I need to use a drop-down or pop-up value list (can't use a portal, for example). The values come from a related table. The values to be selected are unique. The values in the field I want to sort by might not be, so I can't use it as the first field. The values in the sort field are meaningless to the user, so I don't want him to see them, even during the actual selection process.

Is there a way?

[Søren Dyhr]

If you should be so lucky that all employees are on mac's could this be used:

tell application "FileMaker Pro Advanced"

	set aVar to cell 1 of current record

	words of aVar

	choose from list result

      set cell 2 of current record to result

end tell

The point is that GetNth( can be set to look at different sortorders of the same table, via Choose( and put it in cell 1

--sd

[macavity]

ohhh, that would be nice. Some are on Mac but, unfortunately, most aren't.

[macavity]

ohhh, that would be nice. Some are on Mac but, unfortunately, most aren't.

[Søren Dyhr]

There is a great problem, with users who tab from field to field, since it then need to be scripted, filemaker doesn't provide event triggers right out of the box and you need to rely on 3rdparty tools!

When the trigging is established aren't there much choise either you make a new window with the maters you couldn't find real eastate for

.... or to fake them in the present layout, but then has the the ties to the relations to evaporate, and you must make x number hardwired valuelists, each having their own flow. Then must each of them be attached to their own copy of the field, which then is stacked after each of them have been given their own objectname and a position in the taborder!

Indeed a spit and polish kind of job!

The template I attach, reqires the user to click into the field, and dependent on the choise of number next to it will differnt sortorders show up for the popup.

--sd

popsort.zip