Moving fields from one table in a file to another is it possible?
So i currently have a file with 1 table that has about 5000 records, and I am looking to split all the fields into multiple tables.
Is it possible to move fields from table 1 to table 2 and have all the data transferred with it? Right now the only way i can think to do this is.
1) export all my records and fields.
2) create a new file with all the needed tables
3) re-import the original data back into the new file with multiple table.
I would prefer to not have to do this since it will require me to have to re-create a brand new file and then worry records might get changed during the export/import process.
thanks for the help.