Basic SQL/CakePHP

Need Help
1

I created a Cakephp project, build on a Mysql database whic contains One to Many, Many to many associations among others.

The thing is; I want a page with a formulary on wich one can introduce data related to various tables (so far, I only have the tables with their associations as they are show in the automatic templates CakePHP generates, which oftens reffers to data on other tables by their ID, and not by other useful features, like the “name” field)

The question is; How this “summay table” must be build? through a “costume query” joining tables? or by “engineering” the database tables including more relations that needed?

Help please!

2

Your question is unclear for me.

If the tables are associated than you can access them through the association.

If you ant something like a dashboard where you can do administration stuff for more tables, than view cells might help.

https://book.cakephp.org/3.0/en/views/cells.html

3

Yup, that’s the thing, a Dashboard type of table where you can enter the data corresponding to different tables. Thanks, I’ll give it a shot!!