Copy value from one table to another

[argonaut]

Following the database relations I want to copy a value from a field of one database to a field to another database. In the database there is a table “members” and a table “whishes”. A whish can be placed by a member and another member executes the whish. So the member-id is twice placed in the whises table (ask and execute). How can I copy to different names (from member-id) from the members table to the whishes table ?

LibreOffice 5.0.3.2, Win10 home

[edit: speling]

PS

Is that supposed to be ‘wishes’ (as in ‘desires’)?

[argonaut]

yes, the members of the organization help each other with small (diy) works (fix a plug, paint, do the garden etc). the front office registeres the members with possibly the help they can offer. Members come to the helpdesk to ask for help (whishes / desires ?) .
This is why in the member table you find all the members, both people who ask a whish as people who want to help. In the whish table I want to register both parties as well as dates, comment and results.
the whishes are devided into several specialties: elec, admin, garden etc.

[frofa]

It seems like you are talking about copying data from one TABLE to another in the SAME database (not between one database and another). If so, you don’t need to copy the names to the “wishes” table at all. Instead just write a query to JOIN the tables using the member-id as the linking key. That way, you avoid duplicating information in your database.

[argonaut]

you are right about the table (not database)
your answer means for the query that on two positions I find a member-ID. To pick the right record from the whish-table I like to use a grid. In this grid the member-ID doesn’t work for the users, they want the (full-) name. So, to make a query for the grid, on one record I must add two different names (whisher and helper). I already tried a button, a selectionlist (with and without input line) but that gives to little overview. The grid is oke