create "Files As" field like Outlook

[Stephen S]

Is it possible to create a File As field like Outlook, in a contacts database that not only reflects 1st Name/Last Name but also takes into account the Company name field (which uses the 1st name as the 1st sort). Thus when sorting alphabetically, names and companies will be sorted together.

[Osman]

You can do the same thing; sorting by your new calculation field which has the formula below:

"if(isEmpty(name);company;name)"

Adam Djuby