Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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.

Please Log in or Create an account to join the conversation.

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

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 ...

Please Log in or Create an account to join the conversation.

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

any one please provide solution for this?????

Please Log in or Create an account to join the conversation.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
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 following user(s) said Thank You: dyvel, jcombuilder

Please Log in or Create an account to join the conversation.

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

Hi!

Did you find a solution ?
I have the same problem...

thanks!

Please Log in or Create an account to join the conversation.

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

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 :-)

Please Log in or Create an account to join the conversation.

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

Bump :-)
Any news Chef, about this feature? I'm sure many of us is really looking forward to the day when it's implemented.

Please Log in or Create an account to join the conversation.

Last edit: by dyvel.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
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

Please Log in or Create an account to join the conversation.

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

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
Coming any time Soon?

Please Log in or Create an account to join the conversation.

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

  • JuJ
  • JuJ's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thank you received: 3

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.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.620 seconds

Real time saver and great Component Builder tool ! I have been developing with J-Cook Pro Component Builder for several months now and can say with all honesty that this product/service is second to none. The product is feature rich and is being improved and added to all the time. Do yourself a favor if you need to build a Joomla! Component then you can do no wrong in trying the product. You will save on time and effort while being able to deliver your project on time. J-Cook pro does the hard work for you you then have the freedom to fully customise the end result for your own needs. 

One word: Awesome.
Edwardcox (JED)
         

Get Started