Last post Sep 07, 2009 10:56 AM by deathcab001
Sep 03, 2009 10:29 AM|deathcab001|LINK
Hello Everyone, right, I know i've done this a few times before, but it's been a while and I've completley forgotten!
I have two tables:
What i want to do is be able to open the dates table, and there's usually a little plus icon beside it, so you can expand it and it will show all events from the event table that match that date. I have been playing around with relationships but its not
What have i done wrong?
Also, does anyone know if I can use it like this in a repeater? e.g. Have the date show, then repeat through all events for that date, then show the next date, and repeat through those events after. Or am i possibly looking at repeater in a repeater?
Sep 05, 2009 11:48 AM|TATWORTH|LINK
What is is the relaionship between the Dates and the Event table?
Which version of SQL Server are you using?
Are you trying to join on Date?
Sep 07, 2009 10:56 AM|deathcab001|LINK
thanks for getting back to me. I figured it out in the end. there was a problem with the type of relationship i had set up.