Calculation fields are not editable, so you would need two full name fields. Replace table with the name of your table.
table::FullNameCalculation this field would not be displayed on the layout (Can be but is not required)
table::FullName this field would be displayed on the layout.
You would then have a script trigger OnObjectEnter on the FullName field that is displayed on the layout with the following script
"I’ve tried to do this several ways already using the “auto-enter: calculation” box under a text field"
I think that you are on the right track but, to calculate the old fields, change it to a calculation field, close the "Manage Database" window, then reopen it and change back that field to auto-enter: FirstName & " " & LastName, remembering to uncheck the box "Do not replace existing value of field ( if any )"
Thank you both very much. I'll try both methods and see if I can get it working either way. I really appreciate the help.
You might want to try a different approach. Assigning a "parent key" to each author and linking that to a "sibling key" for each book. A fundamental building block to all good databases. Then you wouldn't have to worry about spelling.
Thanks to everyone. I ended up using both methods. The calculate and switch to fill in all the fields, and then the script approach with new entries. It works quite well now.
Brent, thanks for pitching in! I have the two tables linked with a join table. It's actually a many to many relationship because books can have more than one person associated (co-authors for example) and people can have many roles on a book (editor and contributor, for example).
This problem was only because I wanted an easy way to keep track of everyone's full name and also the name that they're known by.
Thanks to everyone for their help!