Okay, so we have two form elements: NewLastName and NewFirstName.
First - add two Variables in the Control panel. Their type is Form, and their names are NewLastName and NewFirstName. Set the Left and Right Padding to single quote ', and set the Empty target to NULL. Also set the Target of the replacement values to @NewLastName and @NewFirstName.
Next, Add a button, or a Link to your page which will submit the data. For the example - lets place a link -
SaveOkay - now - you need to create the Action script to save your data. If you loaded the record from an existing record, you will need that value, but for this example, it appears you desire the ability to INSERT a new record.
1. Add a message action - ACTION:Message with a Type, Toolbar and a Name Save which acts as the listener for our link click.
2. As a child of the Message Action we just added - Add an ACTION:Execute, setting the Name of the execution to NEWRECORD and the Query to your insert statement - for example:
INSERT INTO myTable(FirstName,LastName) VALUES (@NewFirstName,@NewLastName)
SELECT SCOPE_IDENTITY() newID
I assumed that myTable would have a primary key, and I returned that here. If you need to do something with that identity value - you have access to it via the ListX tag [newID,NEWRECORD].
Got it?