[libreoffice-users] Help with LO Base

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