Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Let me give some example background to see if this can work.

Let's say we have an "animals" database, for someone maintaining an animal
shelter.  Each animal has a list of "medical care events" and also a list
of "adoptions" (some animals return to the shelter).  The
"medicalCareEvents" and "adoptions" tables each have a FK to the "animals"
table.

What I'm envisioning is a report that lists the fields for the animal,
followed by an indented section showing a row for each medical care event,
and another indented section showing adoptions for each animal.

A query could potentially use a join to create individual rows composed of
data from multiple tables, but that is really only practical for 1-1
relationships, or possibly 1-verysmallinteger relationships.

If you still think this can work, could you explain how this would be done?


On Wed, May 15, 2013 at 2:27 AM, Alexander Thurgood <alex.thurgood@gmail.com
wrote:

Le 15/05/13 05:42, David Karr a écrit :

Hi David,

If I have a main entity, and I have two one-to-many relationships to
other
tables (FK links from the other tables to the main table), is there any
way
to generate a report with the main table data, and the data for the other
relationships also included (indented and formatted properly)?


Perhaps I'm misunderstanding here, but surely using a Query or a View
which pulls in the data from your 1-to-N tables, grouped as you want
them, as the basis for your report, would suffice ?


Alex


--
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.