> So, for that contact, I added " 1" at the end of the company name
I really don't like your way to sort your customer list, but what about adding " -" ?
Sorry that you don't like the way I sort my list. Sheesh!
Actually, just eliminating the 1 and leaving the extra space after the company name worked.
What would you think about this:
In your contacts table, add a text field that you will use as a checkbox to label a contact as a "Primary" or a "Secondary" contact.
Then, change your calculated sort field to:
Company Name & " - " & Case ( Type = "Primary"; "*"; "" ) & NameFirst & " " & NameLast.
You can have the new field default to either Primary or Secondary (your preference). You get the benefits of your primaries at the top without altering their first names, and an asterisk in front of their names feels less weird than a "1".