Hi i have two table
table1
Filled name is
Code
Name
Salary
Checkedbox
I need if i select Checked ✔
Copy data is selected to anoher table2
If not remove from table2 and keep it in table1
Thanks
Hi i have two table
table1
Filled name is
Code
Name
Salary
Checkedbox
I need if i select Checked ✔
Copy data is selected to anoher table2
If not remove from table2 and keep it in table1
Thanks
In general I think most of us here would recommend against moving data back and forth between 2 tables. You can use a single table, and with a query either get all checked, all unchecked, or both. Your situation sounds like employees that have left, which I would definitely leave in one table with a status field (your checkbox if it's just 2 options).