Forum Discussion

ForrestParker's avatar
ForrestParker
Qrew Cadet
7 years ago
If there isn�t duplicate data in the tables then you just need to import the data from one of the tables into the other.

1) run a report (with all of the data) from one of the tables
2) choose �save as spreadsheet� from the �more� menu
3) copy the data in the spreadsheet to the clipboard
4) go to the other table and choose �import/export� from the �more� menu
5) choose the �import into a table from the clipboard� option
6) make sure all of the data will be uploaded into the correct columns and finish the import
  • JayaKrishna's avatar
    JayaKrishna
    Qrew Trainee
    7 years ago
    Hi,
      
     I want to merge all 5 tables data into 1 new table, And all these 5 tables 
    contain the same field names, And also there is no relationship between these 5 tables.
    whenever I perform Add/Edit/Delete Action on each individual table the data should be updated on this newly created table.