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.

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

Thanks Chief!

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

Best.