SQL queries / Multiselect / Textselect

I've got a item type called "Event" that has several fields associated.

One of the fields is "Speakers".

I'd like to be able to select more than one speaker to each event, and if the name doesn't exist than create it on the fly. If it was only this it was easy, a simple textselect field was enough.

The issue is that this field repeats several times in the form and besides that I'd like to be able to manage this speakers so that I could create a biography for each one of them.

Is there any way to achieve this? Some kind of workaround?!

Thanks

I even remembered of creating an item type of name "speakers" to which I would associate several fields and where would manage these speakers.

Then, in the item type "events" I would populate the multiselect lists needed with the names I would fetch using a SQL query. But what should be that SQL query?

And this way it's not possible to add in the events form a new name that doesn't exist, is it?

Hello


why don't you use the relation (related items) field ?

Because I don't know exactly how does it work!

Hello

it is the most appropriate / natural way to achieve what you need
- you can create relate items of type "Speaker" to the items of type "Event"

Just look at the available configuration options in the Editting TAB of the field


1. Create the new field and "assign" it only to type "Events"
(so that it appear only to item form of "Events")

2. Select it to shown only items of type "Speakers"

3. Optionally enable options like drag and drop sorting of its values (aka of speakers) in item form

4. In viewing TAB (when field appears in frontend inside an event) you can select not only to display the name of the speakers
-- but anything about, them, e.g. their image, or anything

5. In category view it can display differently than in item view, e.g. in category view you can configure it to show only a total number of speakers or only their names etc

test it, its usage is documented inside the popup descrtiptions of every parameter

Thanks.
Sorry for my late reply. I've been out.
I'll try your suggestion.