I have a List called "List_Vacation Plan" that has 3 columns.
Each Column lookups to a different List. 1)List_CountryLookup 2)List_StateLookup
Column_Country -->Lookup to ---> List_CountryLookup
Column_State -->Lookup to ---> List_StateLookup
Column_City -->Lookup to ---> List_CityLookup
There is a cascading relation between Column_Country ,Column_State ,Column_City. (Column_State populates based on the Column_Country selection, and Column_City populates based on the Column_State )
Now, i have around 200+ data in the List_StateLookup , and List_CityLookup. So when we are trying to add new record to the List Vacation Plan, the Dropdowns (Column_State , Column_City ) are taking long time to load.
Is there any way i could cache the data in these 2 dropdowns, or cache in the page level so that the dropdowns loads faster?
Thanks in advance.