I have one general bank table receiving information from other tables like sells and other like purchase. Then some lines at the bank table came from sells and other lines from purchase. I am doing that process with calc but it take too much time (I am not expert in base). Sometimes the values from bank are not exactly the same as sell tables (like credit card sells) then i need to select manually from the sell table and hopefully in a way of a list. Then what i need is to copy some fields from one table ( in a list, from i can select a particular field) to another field in a second table.
Best regards
EDIT_ebot_2020-12-04; Answer from @Rafaelmysql inserted here, answer deleted:
Hello, The database is at external server (mysql over CentOS ). I access that database using Base from Libreoffice 6.0.7.3 version over Kubuntu 18.04.10. I create the database using PhpMyAdmin 5.0.3 What i want to do is copy some fields from one row at the source table to a destination fields at the destination row of the destination table. It is similar to use a Query function as Inser (Insert into…Select…From…Where…Between), except there is only one destination row at the destination table and one source row at the source table, with severals fields to copy every time. Is the operator responsibility of this procedure to select the right source and destination, because there is not direct relationship between source and destination tables. This process should be done using database to avoid mistakes using spreadsheet of several users in different places. I have some experience with macros in Microsoft Office but not in Libreoffice. Rafael