The default ACT!@ database provides First, Middle and Last Name fields that are system fields. It also includes an all inclusive Contact field. Names entered in the Contact field are parsed into the individual name fields Lookups use the individual fields but a sort by the contact field uses the last name.
