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