I have two tables. table 1 project list and table 2 archive list, both tables have same fields.
table 1 have a field status having two options running or archive.
i am looking an option when i change the status option from running to archive the current data should be copied to table 2 ie archive list.
hope some can help me.
thx