I want to move a data in the form from a table to another table (for example if i'm filling the form for an employee i take on status ACTIF, the form go to table name ACTIF_EMPLOYEES, also available on query ACTIF_EMPLOYEES, and so on for the status to other table)
I received solution on forum telling that i need to implement BeforeEdit event where i can check status field value and move record to another table.
CODE
if dict("status")="Fired" or dict("status")="retired" then
...
' insert a new record into archive table
...
' delete record in original table
...
end if
PLEASE HOW CAN I IMPLEMENT THAT FUNCTION, AND WHERE TO ADD IT PLEASE (DO I ADD IT ON ACCESS OR WHEN I BULDING THE ASP PAGE ON THE EDIT PAGE )
Thank you for answering
