What you need to answer your question is described in the LibreOffice
Base Handbook available at this link:
https://documentation.libreoffice.org/en/english-documentation/base/
It is available in both the .odt (text format) and PDF for version 4.0.
Several years ago, AOO and LibreOffice split over disagreements
producing two variations of the same software. So, this guide's
instructions will work for both. Unfortunately, I could not find a base
guide for OpenOffice.
However I will mention this much. The first step is to create a
relational database with the two tables you mentioned. Then create a
query which combines these tables in which the relationship between the
tables is defined. From here, detailed instructions are needed to
create the report you want. (This is why you need a guide to help you
with the specific steps.
Dan
On 11/23/20 04:47, DAB DAB wrote:
HI, I have two tables in a database, Customers and Dogs. One customer could
have more than one dog.
I want to create a report which shows the customer details on one line but then
the list of dogs that the customer owns before the next customer line and so
on. For example:
John Deacon 18/05/1968
Nelson, Cocker Spaniel, Male
Loki, Cocker Spaniel, female
Barbara Barker 18/05/1975
Patch, Springer Spaniel, Male
Karen Brighthouse !8/06/1985
Nelson, Springer Spaniel, Male
Bruno, Labrador, Male
What is the best way to achieve this?
Thanks
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
