Sortname

[DigitalDreamer]

Hello everyone. I was wondering if someone can help me. I hope im placing in this in the right section of the forum. Im new to the forum and FM.

I gotta membership base that has some simple fields like Name, Address, Phone and things like that. What i have is 2 fields im trying to tweak actually 1 but you'll see what i mean. I got 1 field simply called Name and below it i have a field call Sortname. I want to be able enter a name into the the field name example: John E. Jones but automatically put in the sortname field Jones, John E.

Does anyone know if this is possible? Thanks for anyhelp you can give?

[LiveOak]

It's a better idea to have fields: FirstName, MiddleName, LastName. The problem with having a single field "name" is that the variations of how names are entered will frustrate most calculations. If you use three fields for name entry, you can sort by LastName and FirstName to accomplish what you wish. You can also create fields:

FullName (calculation, text) = FirstName & " " & MiddleName & " " & LastName

LastFirstName (calculation, text) = LastName & ", " & FirstName & " " & MiddleName

-bd

[DigitalDreamer]

LiveOak thanks alot that worked perfectly. I did what you suggested and made the 3 fields First, Last, and Middle for sorting purposes. With what i learned with your help i tweaked a few more fields and it works great. Thanks again and take care.

Dave