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
