Ask Your Question
0

copy field from a list to other table on base

asked 2020-11-21 12:57:55 +0100

Rafaelmysql gravatar image

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 retag flag offensive close merge delete

Comments

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. https://www.youtube.com/playlist?list...)

GNK gravatar imageGNK ( 2020-11-21 13:29:22 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2020-11-21 18:08:02 +0100

Ratslinger gravatar image

updated 2020-11-24 05:48:19 +0100

Hello,

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?

edit flag offensive delete link more

Comments

@Rafaelmysql,

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.

Ratslinger gravatar imageRatslinger ( 2020-11-23 19:05:37 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2020-11-23 19:06:55 +0100 )edit
0

answered 2020-11-23 13:07:52 +0100

Rafaelmysql gravatar image

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

edit flag offensive delete link more

Comments

@Rafaelmysql,

Please do not post further information as an answer. Answers are to respond to original questions. This should be a comment or an edit to original question.

Please see comment under my answer for response.

Ratslinger gravatar imageRatslinger ( 2020-11-23 18:54:32 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-11-21 12:57:55 +0100

Seen: 54 times

Last updated: Nov 24