My apologies if this has already been answered. I did search but couldn't find it.
I am using Self Servicing code generated by version 2.0 with .NET 2.0.
My problem:
I have a Survey table and a SurveyNomination table.
Survey and SurveyNomination are related 1:n, SurveyNomination also contains a UserID column that is of interest here.
I would like to retrieve a Surveycollection, but filter out those Surveyentitities whose SurveyID exists in the SurveyNomination table (ie. a related row is present) for a specific UserID in the SurveyNomination table (ie. if the UserID in the related row matches a given value).
I hope I have made the problem clear enough.
Any help would be much appreciated.
Thanks
Sumeet