Helder Meneses
|
Posted: 01/17/2002, 4:04 AM |
|
hi there again,
i want to insert a record in a table named status where i have a list of status dates. like this: when i insert a issue i would like to save in the status table the date of the status "open". and in the future when i change the status to "resolving", i would like to insert another record in the table status with the date that i changed the status open for resolving.
the table with the status that i choose is "estados", and the table with the records of the date of changed status is "historico".
could you help me?
thank you....
Helder Luis Meneses
helder.meneses@oninet.pt
|
|
|
Nicole
|
Posted: 01/17/2002, 5:12 AM |
|
Helder,
do be able to insert/update/delete any other table different to one selected on the form you should add proper custom code to AfterInsert and/or AfterUpdate events. The code should contain query execution.
As for adding date you may refer to CC examples (lets say BugTrack) to find how to do it.
|
|
|
|