OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Merging Base tables

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
MHB
General User
General User


Joined: 19 Mar 2009
Posts: 12

PostPosted: Wed Apr 01, 2009 2:50 am    Post subject: Merging Base tables Reply with quote

Hi,

I did try to help myself first but could't find a thread on merging Base tables. If someone could explain how this is done that would be great. Please don't be too technical because I am a layman.

Thanks.


Last edited by MHB on Thu Apr 02, 2009 4:09 am; edited 1 time in total
Back to top
View user's profile Send private message
MHB
General User
General User


Joined: 19 Mar 2009
Posts: 12

PostPosted: Wed Apr 01, 2009 3:02 am    Post subject: Reply with quote

I got it.

Do you really need them in one file? (It can be done, but I don't have the answer to that at my fingertips. See below though... but first.. at...)

http://sheepdogguides.com/fdb/fdb1joins.htm

... you'll find information on displaying fields from multiple tables in one query, using a joins.

the tutorial is a bit long-winded.... skip it if you "just want the answer". There's a link allowing you to download the finished database.

Back to your question...

It would probably be possible to...

export the two tables to separate pages of an ooCalc document,
use ooCalc to merge the data...
--- You would need to create a third page with what you want for each "combined" record" displayed on a line of the worksheet
And then "copy" the data into a new table.

For some of the details of doing something by that route, see....

http://sheepdogguides.com/fdb/opof1xfer.htm"
Back to top
View user's profile Send private message
MHB
General User
General User


Joined: 19 Mar 2009
Posts: 12

PostPosted: Wed Apr 01, 2009 3:14 am    Post subject: Reply with quote

And it worked like a charm.

Many thanks guys as usual.

rk
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group