Thursday, 28 May 2015

how filter data between two lookups

How to filter the data between two lookups

1.I have added Two lookup on form Called State And City

2.

3.the my requirement is i want to display city according to state 

4.at initial statge my city lookup will be look like this


it display all city of all state now i want filtter it according to my state 

5. for this u just need to double click on city filed and scroll down their is one sub grid given 
related record Filtering 
click on only Show records Where 


then click ok and publish it 

6.your output will be look like this






No comments:

Post a Comment