Two inputs into one DB field
Hi there
I have a form created within DA and two of the fields capture a person's first name and last name. These go into their own respective 'first_name' and 'last_name' fields in the database, but i would also like these inputs to go both together into one extra field called 'full_name', separated by a '-'. So if 'John' is entered into 'first_name' and 'Smith' entered into 'last_name' I would like 'John-Smith' to go into the 'full_name' field.
Any advice would be greatly appreciated.
Many thanks in advance
Paul