I have three lists created at the very top of the site collection. I
then created a content type and added the lists to the content type
and then attached the content type to the document library for used.
My question is, can someone help me figure out how to filter my
lists.
My three lists are:
Country:
-Canada
-USA
Province/State:
-Alberta
-California
-British Columbia
City:
-Edmonton
-Calgary
-LA
So for example, I want to create a document using the content type
that i attached in the document library. When i pick a country from
the Country list, I want Provice to filter only province based on
the country. And when i pick a province and only want all the city
that are in that province. For example: I pick "Canada" from
Country list, in Province/State list: only "Alberta" and "British
Columbia" in this list would show. And when I choose "Alberta", City
list would show "Edmonton" and "Calgary" only. Can someone please
help me with this please.