Looking for a little help on how to approach this. I have a field that automatically generates the age of a person based on their date of birth. What I'm trying to figure out is how to generate a string of text on the condition that said person is over 18 and then place the string of text into a field before their full name.

The text string would consist of the parent's name (located in another field), the text "A/N/F of" and then the child's first name, middle name (if they have one) and last name. So the end result if the child is a minor would be " John Smith A/N/F of Jane D. Smith"

Any help would be appreciated.

Thanks

Create a new calc field, result text,

dsp_Minor=

if ( Age < 18, ParentFullName & " A/N/F of " & ChildFullName, "")

where ParentFullName and ChildFullName also calcs concatenating First and Last.

(at one point you say over 18, and later you say is a minor).

This did the trick.

Thanks so much for the help.