Looking forward to make it clear which system offers the most efficient way to manage many-to-many relation I am going to check Zoho Creator. The examples for testing are the same: Students and Courses.
Check out the look of table Courses:
And this is the table Students:
This is the table with info on courses the student attended and the marks he got.
This is how the data is added into the table:
That’s it. There is not that much you can do in Zoho Creator without a use of deluge script. Thats why I sent a request to Zoho Creator Support and asked them to give me a hand to setup edit/view attende data from student's or course's side. I also asked for help and explaination how to create a report that shows the info on the most popular (most attended) courses among students from different countries.
Mr. Hariharan, Zoho Creator specialist was very helpful and cleared up how to solve these tasks. Here are the details how everything works and how to customize it.
Check out the look of view/edit data on courses on student’s side:
And this is the piece of deluge script that allowed tuning this screen:
The report on course preferences of the student looks even more impressive:
But the user must be aware of the code they should to code to create this report:
Besides, it was necessary to write an auxiliary function to create this chart:
Everybody must decide for himself if he is ready to turn into deluge scripting guru or not. Who got interested and wants to specify in-depth peculiarities of this set up you can check it here.
I must say deluge script is very powerful and flexible tool. And will be of a great help to tune a whole lot of things in your Zoho Creator application. It’s quite a question if you can master it. You should know at least the basics of html and how algorithms are composed. This is where an important question arises: Do business users know all that? Don’t think so.
My point is if one way or another you picked Zoho Creator as a service to stick with and you are a business user with the exact know WHAT YOU NEED to do, be ready you’ll need at least one assistant (developer) that KNOWS HOW TO.