Re: [libreoffice-users] Help with LO Base

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 have a feeling you have already done that but it's the simplest
thing that might have gone wrong.
Regards from
Tom :)




On 14 May 2014 14:54, Victor <victorbello@usal.es> 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 problem:
>
> I have a "table A" with about 12000 records, with their IDs 1-12000. Then I
> have other tables where some of those records have more data, and some
> records are not present. I mean, in Table B, there are records 1-1000, in
> table C 1001-2000, not necessary in that orther, but the point is that some
> records are present in the tables are some aren't.
>
> When I try to retrieve data from several tables, I'd want to have all the
> records, no matter if they are present in all the tables or not.
>
> I don't know what kind of relationship I need to create so when I run a
> query to retrieve data from many tables at the same time, if a record is
> not
> present in a table, then the columns for that record in that table should
> be
> empty, but instead of that i'm getting things as the correct data from
> table
> A, but then in table B I only get one record repeating in all the rows.
>
> I hope I've explained myself clearly enough so you can help me.
>
> Thank you very much.
>
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Help-with-LO-Base-tp4108795.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted