At the moment I have a form and a button to insert record row into a table.
However, I want to write another SQL Update query to update record if user did not fill out FirstName field I want to use FirstName data from the previous row.
For example:
Row 1:
John Doe 56 Male
New insert:
<EMPTY> Johnstone 65 Male
I want my new result to be: (Row 2)
John Johnstone 65 Male