having option to insert data from 1 table to multiple different tables
Posted on 2011-05-09
exporting data from table and deleting data in table after data exported:
Usually when I move data from 1 table to another and then have data deleted after exported- i will write something like:
Insert into tbl1
//and to delete
Delete tbl2.[ser no], tbl2.[item number], etc...
Where (((tbl2.[ser num] IS NOT NULL)));
But now I am confused- I have a database with 25 tables and user wants capability to send data from any one of 25 tables to any one of other 25 tables-( also deleting data from table after sent)
Is there any short way of doing this?
I have only used command button ot send do it between 2 tables.