rclayh
|
| Posted: 05/27/2003, 8:27 AM |
|
I have a record form call from a grid that is designed to allow the user to select a value (a user) for a task. The task id is passed to the form, along with a hidden variable identifying who is assigning the user to the task.
The problem that I'm having is the record form is pulling up a record from the database that closely matches the variables passed rather than populating the fields and putting the form in insert (add) mode.
I've tried blocking the parameters, and even set the form to not allow update but I need it to stop pulling from the database and changing mode. Is there a simple way to do that in CCS?
|
|
|
 |
rrodgers
|
| Posted: 05/27/2003, 10:48 AM |
|
Are you passing the primary key in anyway to the update form? It sounds like you are. CCS thinks if you pass the primary key to an update form that you want to update the matching record rather than perform an insert.
rob
|
|
|
|
rclayh
|
| Posted: 05/27/2003, 11:14 AM |
|
I wasn't passing the primary key, I think Code Charge was matching on some fields. I did finally solve the problem. I modified the query to require the primary key (added WHERE TaskUserID = URL TaskUserID). Since that wasn't being passed, it no longer found a matching recorde.
|
|
|
|
|
