The Field Name is lastfirst. For display purposes, I can ask for Last_Name or First_Name and it will derive the Last Name or the First Name from the lastfirst field. Unfortunately on the input screens you must put the names in as "last, first" which can get annoying. I would like to find a way to concatenate the two fields on the fly for input.
So I want to have it display text boxes for the following:
But if the form is submitted with changes to either field, it concatenates the incoming information into the necessary "last, first" format for entry into the database.
Mine[codebox]<input type="text" name="First_Name" value="" size="15"> <input type="text" name="Last_Name" value="" size="15">[/codebox]
Theirs[codebox]<input type="text" name="lastfirst" value="" size="30">[/codebox]
Make any sense?