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