Re: [libreoffice-users] Help with LO Base

2014-05-14 Thread Fernand Vanrie
On 14/05/2014 15:54, Victor wrote: Hello. I'm a new user of LO Base, and I have some problems that I haven't be able to solve with tutorials. I'm making a db with several tables with many records in each one, and I want to retrieve records from several tables at the same time. Let me explain my

Re: [libreoffice-users] Help with LO Base

2014-05-14 Thread Heinrich Stoellinger
Hello Victor, I don't know how deep you are into relational database theory, but I suppose you have defined all the necessary "foreign-keys" (= IDs) linking the tables together. Having done so you have to use (eg.) a "left outer join" to "combine" the correct info in the various tables. If you us

Re: [libreoffice-users] Help with LO Base

2014-05-14 Thread Tom Davies
Hi :) I think the tables that have information for only some of the 'people' in Table A need to have a dummy record to cover that case. So you might have 1 row of all zeros, or whatever is suitable to indicate a lack of data. Then all the people with no data just point to that single row. Err, i

[libreoffice-users] Help with LO Base

2014-05-14 Thread Victor
Hello. I'm a new user of LO Base, and I have some problems that I haven't be able to solve with tutorials. I'm making a db with several tables with many records in each one, and I want to retrieve records from several tables at the same time. Let me explain my problem: I have a "table A" with ab