Hello All, I am new to Umbraco. I been a asp.net programmer for over 10 years now. Just wanted to start my new project with something that has some features pre built. But I am having some hard time getting some basic stuff done. Need to learn umbraco a bit more. (also the search on forum didn't really give me what i need)

I am Creating some custom fields for member memberType. Want to add a database table where I am going to store State, County, City Informations. This is obviously a big table or even multiple tables depending on the data, so I want the User to use multiple select dropdowns. And obviously the lists are going to populate using some javascript json calls to the server. Preferably jquery post request, but not limit to it.

I was thinking this could be a view or macro or data type some sort or something else but which one would be the best approach to get this done. In the past I would have coded this but I want to use the existing system as it designed. Also I just cant seem to find a way to Import/Export Data for these kinda large Table Info. Curious if I could just use ssms create custom tables but the system has a lot of existing structures don't want to mess around till I know which does what.

Thank you very much for the help.