Ask Your Question
0

copy value from one table to another [closed]

asked 2015-12-09 19:36:46 +0200

argonaut gravatar image

updated 2015-12-10 20:41:39 +0200

Alex Kemp gravatar image

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')?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-12 19:31:40.915495

2 Answers

Sort by » oldest newest most voted
0

answered 2015-12-11 22:37:22 +0200

frofa gravatar image

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.

edit flag offensive delete link more

Comments

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

argonaut gravatar imageargonaut ( 2015-12-12 22:46:11 +0200 )edit
0

answered 2015-12-10 20:57:34 +0200

argonaut gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2015-12-09 19:36:46 +0200

Seen: 458 times

Last updated: Dec 11 '15