Ask Your Question
0

BASE - Can i connect and see values from a field in another .odb file? [closed]

asked 2014-08-13 09:22:57 +0100

ratrace gravatar image

updated 2016-03-02 00:03:05 +0100

Alex Kemp gravatar image

Hello,

i'm using LO 4.3.0.4 in win xp.

I have a database with clients informations. I want to create another database where i will store contact informations not only for clients but also for colleagues, public services etc.

If i have a common field between two databases, for example "client id", can i see data from the other database (contact informations database)? I want to be able in the database that i have my clients informations, to create a form and see contact informations from the second database (contact informations database) using the common field "client id".

Thanks

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-02 00:03:16.250562

1 Answer

Sort by » oldest newest most voted
0

answered 2014-08-15 00:48:18 +0100

doug gravatar image

Answer is to use two tables in single database. If you need to circulate one table to other people and not the other table ... well, the answer there is to open and ctrl-c table data to a spreadsheet, or open calc and use "data sources" button to load from any database "registered" on your LO installation.

LO Base has ability to connect to pretty much any database, but only one database at a time. Refer to discussion in this thread. Would be a worthwhile enhancement to allow table-by-table connections to other databases, but currently not supported.

To bring information from two tables together, use a query. In query builder, display two tables, create join relationship between linked fields in separate tables, and display the desired columns.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-08-13 09:22:57 +0100

Seen: 757 times

Last updated: Aug 15 '14