September 27, 200520 yr 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.
September 27, 200520 yr You can do the same thing; sorting by your new calculation field which has the formula below: "if(isEmpty(name);company;name)" Adam Djuby
Create an account or sign in to comment