Welcome, Guest

TOPIC: Multiselect as Foreign key

Multiselect as Foreign key 25 Oct 2013 07:14 #11457

nvinfotech
Offline
New Member
Posts: 8
Karma: 0

Hiii...

Is it possible to have a multiselect / checkbox option as a foreign key??

I have a table named 'Dojos' and another table 'Activities'.
I want to select multiple Activities in a Dojo as a checbok multiple select.
But there is no option for that!

Currently there are three controls available: Combo, Radio & List.
All can let me select only one option.

How can I select multiple options here.

Please let me know the solution as soon as possible.

Thanks in advance.

The administrator has disabled public write access.

Multiselect as Foreign key 25 Oct 2013 15:21 #11461

dyoungers
Offline
Premium Member
Posts: 123
Thank you received: 16
Karma: 0

This function has been requested multiple times and admin is aware of it. Having said that, I can see the complications that would arise from this ...

If this is implemented in the strict sense so it supports an SQL join, then it involves a third table linking the primary table with the foreign key table to create multiple relationships (much like the user_usergroup_map table in Joomla)

if it's implemented by storing a list of foreign key references in the primary table then the generated code has to retrieve the values in a separate SQL SELECT which I imagine would cause some other interesting design decisions

For what it's worth ...

The administrator has disabled public write access.

Multiselect as Foreign key 29 Oct 2013 05:29 #11474

nvinfotech Offline New Member Posts: 8 Karma: 0	any one please provide solution for this?????
	The administrator has disabled public write access.

Multiselect as Foreign key 30 Oct 2013 16:20 #11495

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140	Yes, still missing but not for long. Please keep more patience more, it is on the tracks, at least a tutorial for that.
	Coding is now a piece of cake The administrator has disabled public write access. The following user(s) said Thank You: dyvel, jcombuilder

Multiselect as Foreign key 11 Dec 2013 17:48 #11796

ewajoom Offline Junior Member Posts: 36 Thank you received: 2 Karma: 0	Hi! Did you find a solution ? I have the same problem... thanks!
	The administrator has disabled public write access.

Multiselect as Foreign key 19 Dec 2013 19:45 #11823

dyvel Offline Elite Member Posts: 200 Thank you received: 11 Karma: 10	admin wrote: Yes, still missing but not for long. Please keep more patience more, it is on the tracks, at least a tutorial for that. Any news about this feature? It's gonna be killer when implemented
	The administrator has disabled public write access.

Multiselect as Foreign key 18 Jan 2014 21:42 #12047

dyvel Offline Elite Member Posts: 200 Thank you received: 11 Karma: 10	Bump Any news Chef, about this feature? I'm sure many of us is really looking forward to the day when it's implemented.
	Last Edit: 18 Jan 2014 21:42 by dyvel. The administrator has disabled public write access.

Multiselect as Foreign key 19 Jan 2014 03:47 #12053

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140	For the moment no news. I would like to precise that the N:M management will come after FoF. Because there isn't any standard defined for this, I will not try to invent the weel, and then need to change the way of doing. There are many ways. So, when FoF will be included, I will intent to introduce this possibility using the maximum power of FoF.
	Coding is now a piece of cake The administrator has disabled public write access.

Multiselect as Foreign key 19 Jan 2014 07:12 #12057

VeCrea Offline Platinum Member Absolute JCook fan Posts: 473 Thank you received: 100 Karma: 30	Coming any time Soon?
	The administrator has disabled public write access.

Multiselect as Foreign key 19 Jan 2014 21:41 #12061

JuJ
Offline
New Member
Posts: 14
Thank you received: 3
Karma: 0

admin wrote:

For the moment no news.

I would like to precise that the N:M management will come after FoF.
Because there isn't any standard defined for this, I will not try to invent the weel, and then need to change the way of doing. There are many ways.

So, when FoF will be included, I will intent to introduce this possibility using the maximum power of FoF.

Hey Chief,

I discovered J-Cook there's about one year, but I didn't go with it because there's no N:M relations possible for now.
I have a quietly big Joomla project on the way, and I already planned to use J-Cook for this, as this is an incredible time saver. An N:M relations builder would be an amazing news for me. But I don't know what does "FoF" mean...

When do you think this feature will come (even if this is an approximation).

Thanks for the answer.

Best.

The administrator has disabled public write access.