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: [email protected] 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
