Surely that subject makes no sense, but I have more space here....
I'm learning on the fly and cant work out which control I should use to create the following display.
The DB will return a "list" of authors and book titles, where one author may have more than one book. (it's actually a many to many)
i.e.
Fred Bloggs 1001 ways to skin a cat
Albert Humperdinck My lunch has gone cold
Mary Dooberry Say My Name B****
Mary Dooberry Cant think of a decent title so
And for obvious reasons, I want it displayed as:
Fred Bloggs :
1001 ways to skin a cat
Albert Humperdinck :
My lunch has gone cold
Mary Dooberry :
Say My Name B****
Cant think of a decent title so
But due to the complications behind the scenes, I cant just pull out all the authors then a separate query to find the books that they are linked to. It all comes out of one query.
Forgive me if i'm being dense, but PLEASE can someone point me in the right direction?
cheers
I'm learning on the fly and cant work out which control I should use to create the following display.
The DB will return a "list" of authors and book titles, where one author may have more than one book. (it's actually a many to many)
i.e.
Fred Bloggs 1001 ways to skin a cat
Albert Humperdinck My lunch has gone cold
Mary Dooberry Say My Name B****
Mary Dooberry Cant think of a decent title so
And for obvious reasons, I want it displayed as:
Fred Bloggs :
1001 ways to skin a cat
Albert Humperdinck :
My lunch has gone cold
Mary Dooberry :
Say My Name B****
Cant think of a decent title so
But due to the complications behind the scenes, I cant just pull out all the authors then a separate query to find the books that they are linked to. It all comes out of one query.
Forgive me if i'm being dense, but PLEASE can someone point me in the right direction?
cheers