Select field showing items without any Item assigned

I have created a select field width 100 entries this is for all the locations of Portugal.

Example:
- Lisbon
- Porto
- Algarve

I have then created 2 item one for LISBON and one for PORTO.

So I have 0(none) item assign to Algarve, is so, why is it showing in the front-end dropdow?
Could you add a Features for this kind of FC Field that says:

Show un-assinged items: Yes or no

This way in the front end drop down it will only show the fields that have item assigned.

Your post is a little confusing but i think i understand.

The select field will display ALL AVAILABLE CHOISE when choosing a value for the field in ITEM edit form.

This is the expected behavior.

If you want to create a field that displays something dynamic like the TITLEs of items of a specific category then , you must make the values of the select field to be created by an SQL query.

In your post , i think you confused item titles (location) with sting names (locations) defined in the select field.

Regards.

I see that is it.

It is showing all available, but in fact in showed show only the ones that are assigned.

Alternative 1:
Use the select field with SQL mode enable and enter in the textarea this:

To get the item titles of items having category 45 as their main category.

This query will return of course, only items (you use locations as item titles) that already exist. As you create more item (locations) your list will grow longer.

Alternative 2: Also you can use the new related items field and limit it to specific category.

for this you have to wait for the next beta of v1.5.6 (i will make new download soon)

Alternative 3: Use the free available field selectflexiitem
www.sitefaitbienfait.fr/en/downl ... -item.html

Regards

I will try you solution, tue problem with that field, is that it is not FILTRABLE

Will make the selectflexitem filterable, and the related items too