Insert record into another table from a Custom View

OK, I'm an idiot. Jane and Sergey keep telling me to pay more attention to my arrays and I keep forgetting!
This problem is solved by doing an EDIT BEFORE RECORD UPDATE
global $conn;

$strSQLInsert = "insert into tbl_Corrective_Action (p_ID) values ('".$values["p_ID"]."')";

db_exec($strSQLInsert,$conn);
I still need help with Identifying the Q1 - Q4 issue though <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=59308&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Hi Douglas;
If I undertand to you ok I will try:
.- Read the fields in the events with

[indent]$values["MyFieldName"];[/indent]
.- Test it if equal to "2" whit a if and ....
I hope it help you
Aleix

Aleix,
Thanks for responding and it sounds like you are on the right track I just don't understand what you mean or rather how to implement your advice.
Let me restate the problem for clarity sake.
On my edit page in Events BEFORE UPDATE I have this statement:
global $conn;

$strSQLInsert = "insert into tbl_Corrective_Action (p_ID) values ('".$values["p_ID"]."')";

db_exec($strSQLInsert,$conn);
It works as it does insert a new record. Now I want to modify this so that it inserts a new record only if any of these fields are a value of "2"
'Was there adequate chief complaint docs for a dental emergency'

'Was there adequate oral exam documentation'

'Was the diagnostic assessment appropriate'

'Treatment proposed/rendered consistent with plan or complaint'

'Was the medication Rx type/dose/duration appropriate'

'Was informed consent obtained and signed as appropriate'

'Was the type and amount of anesthesia noted'

'Were radiographs taken adequate for diagnosis and labeled/dated'

'Where referrals given when indicated'

'Terminology used clear specific'

'Completed services noted on all areas of record and dated'

'Pre-medication documented as applicable'

'Post-operative documented as applicable'

'Next visit follow-up visit information is noted'

'Consent for general treatment is signed on fact sheet'

'Allergies noted and labeled on front of chart'

'Notes signed by doctor on signature portion of note'

'dte_Dateof Doctor_Audit'
I've tried a couple of different WHERE clauses but I always get an error so the page won't load. Something in my syntax is my guess. I'm just not formatting the where statement correctly I think.
How do I say/write/code
"global $conn;

$strSQLInsert = "insert into tbl_Corrective_Action (p_ID) values ('".$values["p_ID"]."')";

db_exec($strSQLInsert,$conn);"
BUT only if [FieldName]="2"?

Hi Duglas;
You can try this
// Flag down

$flag = "0";
// Look if the fieldName1 is = "2"

$field = $values["fieldName1"];

if ($field == 2)

$flag = "1";
// Look if the fieldName2 is = "2"

$field = $values["fieldName2"];

if ($field == 2)

$flag = "1";
// Repeat this with every field
// At the end, check the flag

if ($flag == 1)

{
global $conn;

$strSQLInsert = "insert into tbl_Corrective_Action (p_ID) values ('".$values["p_ID"]."')";

db_exec($strSQLInsert,$conn);

}
// End code
You can try the code with on field and if it is fine then write the rest and optimize de code
Bye
Aleix