I cant get my head around this...
DiaryID (link to diary ID)
This allows multiple pictures to be assigned to single diary entries..
Easy enough huh. I can display the Diary Entries and corresponding picture(s) easily on a detail page... HOWEVER on the main page where I list all the DiaryTitle's as URL to the detail page, I want to show the number of photos specific to the entry..next to the entry itself.
27/11/2003 Went to Dentist (2 photos)
26/11/2003 Went to shops
25/11/2003 Went home (5 photos)
I know tis is going to include some kind of RecordCount, and GROUP BY, but how can I achieve this....