I can’t copy the records from a table to another. The fields are identical
Hello,
Please provide steps you are using. This is not a normal process in using databases. Also might help if you include the specific LO version you are using, your OS and the database being used.
I wanted to copy the records of a file to another file with the same and identical fields. I distributed a file to three different members of our organization and I wanted a some kind of general list i.e. a compilation of all the information from these three members. I have three member’s list and wanted to fuse them into one as my master list.
My OS: Windows 10
LO Version: 7.0.4.2 (x64)
Database: HSQLDB embedded
Thanks.
Hello,
Will answer based on educated guess. Do not know what you have done previously.
Open your Base file. Open other incoming Base file. Incoming table right mouse click & select Copy. In your Base file, right mouse click the table and select Paste. On dialog presented, insure correct table is shown and that Append data is selected. The you should be able to just press Finish button.
Of course you gave little information. Potential problem here is that the record keys from one source are already existing. In that case, instead of Finish button you need to step through with Next to eliminate the incoming key field and generate a new key provided your file has auto increment key field.
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.
1 Like
It worked. Thanks a lot.