filter many-many foreign key columns RRS feed

  • Question

  • User-693456227 posted


    I am using ASP.Net dynamic data with framework 4.0.

    I have three tables:

    Region with columns(RegionId,RegionDesc)

    Country with columns (CountryId,CountryDesc)

    Region_Country with columns (RegionId,CountryId) - foreign key to above two tables.

    For now only region table can be edited, country table ScaffoldTable is set to false. When viewing the region table in the list page, it displays region description as first column and all countries tagged to this region in the second column. All is fine till now.

    User is now requesting for a filter where they will select a country and only selected country regions should be displayed. Being a beginer in dynamic data i am not sure how to approach on this.

    Any help would be appreciated.



    Friday, April 12, 2013 8:29 AM


  • User-693456227 posted

    I have found a workaround for this change, added a drop down and populated with countries in the list page. Based on the country selection the grid will be filtered.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 25, 2013 1:16 AM