I have 2 datasets, one for Movies and one for Dates. I would like to filter the Movies dataset in a repeater to only show Movies that have Dates listed in the Dates dataset. I have set up the primary key in the Movies dataset to be the MovieID. I then set up a reference field (MovieID) in the Dates dataset to reference the Movies dataset.
When a date and time are added to the Dates dataset for a particular movie, the MovieID is added as well. If no dates and times exist in the Dates dataset for a specific movie, that movie will not appear in the repeater. If multiple dates exist for a single movie, the movie information should only appear once in the repeater.
Please help me get on the right track.