Copy field from a list to other table on base

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 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

It would be useful to express the question in terms of rows (lines?) and columns (fields?) - in calc it is quite easy just to select whole row/column by clicking on its header and use copy-paste …
… but Base does not need great expertise for simple uses…if you can get over the initial hump (eg.


To answer, please edit your initial question or write a comment. **Do not post answers**, if it is not a solution to your question. Thank you.


Your question/situation is very loosely defined. You basic information is also missing (such as LO version, database used & OS).

There are possibly multiple methods to accomplish some of the tasks. Certainly macro’s could provide a solution but this requires knowledge of the process and it appears you may be lacking in this area.

Possibly look at either list or combo boxes (most likely the latter). You can fill these with information from your table. The combo box (fancy text box) allows entries independent of the item list. The list box does not but is important when wanting only specific entries to be used.

Edit 2020-11-23:

This answer has a link which may be of interest → Base: Easy way (function Key) to copy Data from one record to another?


Your further information does not help in giving a specific answer. It is like asking how to build a house when you are not clear as to how many rooms there are or what they are for.

Your question states a table and the new information can come from one of two other tables (that is what I read - sells/purchase). Some sells are the same and some are not. Also, ‘…copy some fields from one table ( in a list, from i can select a particular field) to another field in a second table’. Does not make a lot of sense.

Further comments refer to SQL which requires specifics. There are not specifics. Just vague generalities. In order to present an answer, what specifically do you want? As presented I can envision numerous answers and that is certainly not easily presented. Macros require specific names, fields and data types.

For further information on Base documentation and macros, please see this post → To learn LibreOffice Base are there introductions or tutorials?

Also see edit in answer.