Thank you, it worked great!! I didn't think of creating a new field to hold both pieces, but I don't mind having 2 name fields, as the users won't care, and it gets us what we need, and we can adjust our reports to use the new field only.
Thank you again!!! :)
Qrew LegendSo you wouldn't show both field names on the form. You set the data entry field for the record title to be shown in add or edit mode on the form and then in view mode used to show the formula field where it's combined.
The form lets you control which fields are showing in which moods.
True, I could hide it in view mode, but most of the time when a record is open, users are editing, so its not an issue. But thanks for the tip!
