This problem is caused by a the way Dreamweaver reads variables and using the Underscore Character in your column names.
When a variable is created in a recordset it is name "Param<ColumnName>". Dreamweaver writes the code for the parameter as "$Param<ColumnName>_<RecordsetName>.
upon re inspection, Dreamweaver sees everything after the first underscore character as the recordset name. so the column "Agent_ID" in the "WADAagent_profile" recordset will be named:
ParamAgent_ID
the code for the variable will be written as:
$ParamAgent_ID_WADAagent_profile
When you reinspect the recordset, Dreamweaver will read the parameter name as:
ParamAgent
and the recordset it is associated with as:
ID_WADAagent_profile
To keep the issue from occurring, you should avoid underscores in your column names.
To fix the problem, you will need to manually edit the code, and remove the underscores from the variabel names. change any instance of:
$ParamAgent_ID_WADAagent_profile
on the delete page to:
$ParamAgentID_WADAagent_profile
on the detail page, change these three:
$ParamAgent_ID_WADAagent_profile
$ParamSessionAgent_ID_WADAagent_profile
$ParamAgent_ID2_WADAagent_profile
to:
$ParamAgentID_WADAagent_profile
$ParamSessionAgentID_WADAagent_profile
$ParamAgentID2_WADAagent_profile
On the update page, change:
$ParamAgent_ID_WADAagent_profile
to:
$ParamAgentID_WADAagent_profile