I'am using FM 9. I've created a layout with a calculated field on it.
This calculation makes from 2 fields say ' Mr. Robinson'. If the first
field (' Mr') is empty the calculation returns 'Robinson', if the
first field is not empty it calculates: <firstfield> + <space> +
<secondfield>.
Now I want to sort the record on the second field. But the second
field is not visible on the layout so (?) I can't sort on this second
field.

Greetings,
Kees

In article <fk20m5lamukd0jmitnm23fv3oocv4v1rfq (AT) 4ax (DOT) com>, Kees <xxx@yyy>
wrote:

You can sort on any fields in the parent or related table, whether or
not they are visible on the layout.

There is a selector above the pane that lists the available fields. By
default it is selected to the "Current Layout." However you can manually
select "Current Table" or any other related table.

"Bill" <bbcollins (AT) earthlink (DOT) net> wrote

Yep, it is one of the annoying "features" of newer versions of FileMaker
which catches me out almost every time whenever tyring to use fields. (

Helpful Harry )