Can someone please advise me on how to make dropdown filters appear when using a View? They show up when using a base table, but not when I use a View. For example, these are my tables:
1) AppType: AppTypeID [PK], AppTypeDesc
2) MainApp: AppID [PK], AppName, AppTypeID [FK] - if display this table, then dropdown by AppTypeDesc shows up - so far so good.
Now create View:
ViewAppPlusAppType: AppID, AppName, AppTypeDesc - no dropdowns appear - how to fix this?
If you have trouble configuring the Relationships with the view e-mail me on steve AT NotAClue.net and I can help I also have some custom filters I use just for views.
See my blog C# Bits | Twitter @sjnaughton Always seeking an elegant solution.
None
0 Points
3 Posts
Dropdown Filters do not show when using a View...?
Nov 02, 2016 04:56 AM|tustin|LINK
Can someone please advise me on how to make dropdown filters appear when using a View? They show up when using a base table, but not when I use a View. For example, these are my tables:
1) AppType: AppTypeID [PK], AppTypeDesc
2) MainApp: AppID [PK], AppName, AppTypeID [FK] - if display this table, then dropdown by AppTypeDesc shows up - so far so good.
Now create View:
ViewAppPlusAppType: AppID, AppName, AppTypeDesc - no dropdowns appear - how to fix this?
All-Star
17916 Points
5681 Posts
MVP
Re: Dropdown Filters do not show when using a View...?
Nov 02, 2016 09:35 AM|sjnaughton|LINK
Hi Tustin, you have two options:
Always seeking an elegant solution.
None
0 Points
3 Posts
Re: Dropdown Filters do not show when using a View...?
Nov 03, 2016 03:13 AM|tustin|LINK
Hi sjnaughton, thank you! I will try it and let you know how it works out for me! Stay tuned!
All-Star
17916 Points
5681 Posts
MVP
Re: Dropdown Filters do not show when using a View...?
Nov 03, 2016 10:25 AM|sjnaughton|LINK
If you have trouble configuring the Relationships with the view e-mail me on steve AT NotAClue.net and I can help I also have some custom filters I use just for views.
Always seeking an elegant solution.
None
0 Points
3 Posts
Re: Dropdown Filters do not show when using a View...?
Nov 13, 2016 05:29 AM|tustin|LINK
Hi sjnaughton,
I added an Association & Referential Constraint between the View and (Lookup) Table and the dropdown shows up now! :) Thanks much.
BTW, how can this be done with a Custom Filter? Do you have any sample code you could post here? Thanks again.