Relation field between fields

Hello,

I thinked about a new feature : a new type of field that work "similar" to relation field, but rather than link to existing items, it links to values of another field.
For example :
- We create a text field (e.g. name : textfield). User can create multiple values (e.g. value1, value2, value3...)
- We create the new request field (e.g. name : newfield) and link it to textfield. Thus, in newfield, user can choose between values of textfield (value1, value2, value3...)
- Of course, if we add a value in textfield, it will be added to allowed values of new field.

I think It will be very handy.

What do you think about this ?

Regards.


 

maybe its can be done
did you test textselect field ?
inflexicontent 4 you can set how the select value is construct (existing value, adding value sql) request
with this last feature you can do an sql request in desired table
its a concept but it can works

Thank you very much, it works good
I didn't know we can do this.

Regards.

I put here the syntax I use, if it can help others users.
So I create a textselect field.
In field parameters, tab Editing >>> Form field >>> Element mode : I choose SQL query
And I put this in Element value :
SELECT value, value as text FROM #__flexicontent_fields_item_relations WHERE field_id='775' AND item_id='{item->item_id}' AND value != '' GROUP BY value

775 is the linked field.
And {item->item_id} is used to display only the values of this current item. Otherwise, it displayed all values of all users and all items that use field 775, and it was not the behaviour I wanted.

Thank again Micker.

Hope this help.

Regards.

thanks for share solution !