I have partially created an app to interact with a SQL Server database using cshtml files in Visual Studio.
The app successfully displays a list of existing records with an accompanying button for each record, to display the entire record, with labels for each field, closely resembling the paper form currently used for submitting new records into the approval process.
My next task is to enable the user to submit new(!) requests electronically and track the coordination steps.
I’m assuming this would involve a statement like the following:
INSERT INTO table1(field1, field2, field3, …)
VALUES(value1, value2, value3, …);
allowing the user to omit some fields for which values are not yet known.
What is the complete sequence of steps to “commit” this action?