Can help you achieve this, but it's not only not necessary, it's not good practice generally speaking. This is because you're repeating information in your tables when it isn't necessary. The great part about forms is that they permit the display of information in just about any fashion while allowing you to maintain good design practice in your tables. What you should be doing is having child field that contains every child name for a parent. Thus you would have Bravo as the surname for Dave and Emily, who are children of John (not John Bravo). Your form can assemble values as you wish by using expressions that concatenate values inside of text boxes. The calculated control is visible while the controls that contain the individual parts are not.
That being said, if you still want to do the original thing, have a control on your form that contains =[Name] & " " & [Surname]
I didn't download your file for various reasons.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.