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

TOPIC:

many-to-many db relations 22 Dec 2012 12:59 #6221

  • Julien
  • Julien's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0
Hi there,

Thanks a lot for your work on Cook, this is an impressive component builder. Congratulations!

A question, please:
I would like to build a many-to-many relation between 2 tables. Is Cook able to design it? I didn't see anything about that in the builder, but only foreign keys (one-to-many relations).

Example:
I have 2 tables:
  1. 'Books' ('id', 'name', 'author')
  2. 'Tags' ('id', 'name')

Rule 1: A book can have none or several tags. Relation 0-n
Rule 2: A tag can be assigned to none or several books. Relation 0-n

How can I design this in Cook? Do I have to design an another table between these 2 tables?

Thanks for your answer.

Best.

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

Re: many-to-many db relations 22 Dec 2012 13:08 #6224

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Hi and welcome to the community !
Thank you for your review. Don't forget the JED.

About your question, it is not possible from the builder.

You can follow here :
www.j-cook.pro/forum/9-coding-inside-you...-3rd-level-item#6222

It has been treated several times on the forum.

...and you can try the tutorial (in french for the moment) :
www.j-cook.pro/files/workshop.zip
Coding is now a piece of cake

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

Re: many-to-many db relations 22 Dec 2012 13:36 #6228

  • Julien
  • Julien's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0
Thanks Chief!

I'll have a look to this! :)
BTW, I'm french, so this is not a problem for the tutorials.

Best.

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

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

Hi All just wanted to add one more "thank you" voice to all those who discovered the value of this amazing application. The website I was working on went to production few days ago and I do not want to even try to imagine what would it take to build it without j-cook. So - endless thanks keep it running and evolving I believe it deserves to be the core tool for any joomla application! Thanks!
Michael (bmk028 - Forum)  

Get Started