I was just wondering what is the best practice to perform dynamic filtering on Master-detail tables?
consider the following scenario, i have 2 tables Order and OrderDetail
I have created a filter (county 'WA') on the parent (Order) table; I would like to bring back only the Child(OrderDetail) that are related to the filtered parent record (joined with OrderId)?
1) i am thinking to add a computed columns in the child table so that the same filtering can be applied as of it does as parent.
2) I have read a few articles mentioning that dynamic filtering feature will be availble in the next MSF release? if
so, does anybody have a clue when it will be availble
Many Thanks,