Hi All
I am new to the forum and I am hoping to find more information about how to work around the comprofiler_field_values structure of CB.
Like many of you, my site requests users to provide the country/state/city of their residences. In addition to the registered users, I also have venues that require addresses and locations and for these data, I use tables (country/state/city/venue) external to CB. When a user needs to select a location, he would first choose the Country in a drop down menu, and then the State drop down will be populated with the appropriate choices, and when a State is picked, appropriate City choices will populate the City drop down menu, and then venues in that city will then be presented in a following drop down menu. This is a very common practice and users have little tolerance for anything less.
Regretably, however, the country/state solutions based on CB's comprofiler_fields and comprofiler_fields_value structure seems to restrict the possibility of assigning relationship among the countries and states, thus I am convinced that the aforementioned "intelligence" can NOT be built into with CB with its existing structure. Any thoughts?
If that is the case, then I would have to bypass comprofiler_fields_(values) structure and have CB query external tables for country/state/city and use external JS script to control the menu update. Has anyone done this before? Is this practical or just plain suicidal? Any recommendation on where to start?
Many thanks for your inputs.
SH