Welcome, Guest
Username: Password: Remember me

TOPIC: Multiselect as Foreign key

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

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
  • dyoungers's Avatar
  • 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

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
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3702
  • Thank you received: 974
  • Karma: 141
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
  • ewajoom's Avatar
  • 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
  • dyvel's Avatar
  • 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
  • dyvel's Avatar
  • 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
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3702
  • Thank you received: 974
  • Karma: 141
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
  • VeCrea's Avatar
  • 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
  • JuJ's Avatar
  • 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.
Time to create page: 0.094 seconds

Get Started