ericmuc wrote: Hi,

I tested it now several times and changed some setting. But my situation is with the latest plugin versions:

1) all ok without being part of a field group !
2) cities not saved if both, country and city fields, are part of a field group

I am working with both field as "Query Drop Down (Multi-select)".

SELECT *, CONCAT_WS(' / ', city, subcountry, country) AS label 
FROM #__cities
WHERE FIND_IN_SET( country_3code, REPLACE( '[cb_country]', '|*|', ',' ) ) > 0

Options:
Value Column = geonameid
(unique id)

Label Column = label

Can you please check this?

Thanks, best regards
Eric

SELECT `country_iso_code2`, `country_name`
FROM `#__comprofiler_countries`

SELECT `province_iso_code`, `province_name`
FROM `#__comprofiler_provinces`
WHERE `country_iso_code2` = '[cb_fieldgroup_country]'

SELECT `geonameid`, CONCAT_WS(' / ', `city`, `subcountry`, `country`) AS label 
FROM `#__cities`
WHERE FIND_IN_SET( `country_3code`, REPLACE( '[cb_country]', '|*|', ',' ) ) > 0

But is there a possibility to get the order exactly in the same order as the values were picked out of the drop down list. So the first value will become the 1. value and the second 2. value, no matter in which order they are in the drop down list?

And is it possible to get the choosen values in the profile edit dropable with the mouse so that the order for the profile view can be determined?