Need your help with Risk Management Application questions regarding SQL Statements and Parameters

[Dave]

Firstly must say well done for getting this far with no need to post a question here in the Community! Everything you have done looks great, seriously well done @struppihh

Lets see if can help you out a little (I'm in and out of the office so excuse delayed replies my side) .

@struppihh

My first question here is how I can create the INSERT SQL Statement when adding a new risk score that the risk score is calculated automatically into the column risk_score by simple multiplication of the columns risk_probability and risk_impact (e.g. first line 3 x 4 = 12)

This post will help explain how to sum. You could then use a hidden input within your form to populate it (set its value with the sum) with the result, then post this hidden input to your database. Below are the methods you can use and links to their functions.

* (Multiplication)

+ (Addition)

- (Subtraction)

/ (Division)

@struppihh

I was able to create an insert table to add new tasks but I am not sure how I can create a query that creates a new task and at the same time assigns the new task to the correct riskid in the risk_mitigation table using the URL parameter (in the example risk id=7) so that the task shows up in the correct risk as mitigation.

You would be far better off using hidden inputs/variables to do this, and populate them with an onclick dynamic event or such, with the result data obtained from the query. Then post these inputs as normal within your form to insert to the database.

Or alternatively if you want to pass between pages check this post out for some ideas on how to do so.

Hope that helps @struppihh?