' mkList ' get view, cities.shp (via 0th theme), and display params myView = av.FindDoc("US Cities") myTheme= myView.GetThemes.Get(0) myFTab = myTheme.GetFTab ' declare fields to use stateNameField = myFTab.FindField("State_name") capitalField = myFTab.FindField("Capital") classTypeField = myFTab.FindField("Type") ' initialize arrays and build them with field values stateNameList = {} capitalList = {} classTypeList = {} for each record in myFTab stateNameList.Add(myFTab.ReturnValue(stateNameField,record)) capitalList.Add(myFTab.ReturnValue(capitalField,record)) classTypeList.Add(myFTab.ReturnValue(classTypeField,record)) end ' clean up arrays, removing duplicates and sorting stateNameList.RemoveDuplicates stateNameList.Sort(True) bigStateList = {} for each thingy in stateNameList bigStateList.Add("State of " + thingy) end capitalList.RemoveDuplicates capitalList.Sort(True) bigCapitalList = {} for each thingy in capitalList bigCapitalList.Add("Capital of " + thingy.AsString) end classTypeList.RemoveDuplicates classTypeList.Sort(True) bigClassTypeList = {} for each thingy in classTypeList bigClassTypeList.Add("Settlement class of " + thingy) end ' format output for list bigList = bigStateList + {"----------"} + bigCapitalList + {"----------"} + bigClassTypeList ' return value for other scripts to run as argument return bigList