Concatenate two text fields
I have two text fields - Field1 and Field2. The operator will enter either 1) a name into just Field1 or 2) names into both Field1 and Field2. The result will be entered into Field3. If a name is entered only into Field1, then the contents of Field1 should poplulate in Field3. If names are entered into both Field1 and Field2, then both names should concatenate and populate in Field3 with the word "and" in between the two names. Any help with script is appreciated. Thanks.
