Master/Detail Scenario

May 7, 2009 at 9:30 PM
Edited May 7, 2009 at 9:30 PM
Hello

I'm using Dynamic Data Filtering in a Scenario consisting of two tables with a master/detail relationship:
Accounts is the master table, AccountID its primary key
GroupMemberships is the detail table, with a primary key "GroupMembershipID", a foreign key "AccountID" and a field named "GroupName"

I've successfully managed to set up custom filtering based on metadata information for the accounts table by taking the AdventureWorks sample included in the Dynamic Data Filtering download and adapting it to my data model. However when I click on the Link "View GroupMemberships" the list of GroupMemberships displayed is no longer filtered by the AccountID of the master record as one would expect. As the URL shows,  the AccountID foreign key to the GroupMemberships table is correctly passed to the List template. http://localhost:42147/GroupMemberships/List.aspx?AccountID=2751190. In a Dynamic Data project without the Dynamic Data Filtering functionality, everything works as expected.

Can someone point me into the right direction, please?
Thanks in advance and greetings from Switzerland