First and last name fields?
Proper name entry formats - Do I need separate fields for first name and last name in order to show last name first and first name last in a pull down in another form?
Forum Discussion
If you currently have a field called [Full Name] entered like
John Smith
You can make a new field to reformat that by formula to read Smith, John
Not tested but I think it would be
var text Last = Left([Full Name], " ");
var text First = NotLeft([Full Name], " ");
List(", ", $Last, First)
You can then adjust the Record Picker fields in your employee table Advanced settings to use that field or else on the form where the drop down is, use a report which uses that field for its column.
John Smith
You can make a new field to reformat that by formula to read Smith, John
Not tested but I think it would be
var text Last = Left([Full Name], " ");
var text First = NotLeft([Full Name], " ");
List(", ", $Last, First)
You can then adjust the Record Picker fields in your employee table Advanced settings to use that field or else on the form where the drop down is, use a report which uses that field for its column.
