Multi table

First of all, I want to thank for your wonderful apps.

Chronoforms and ChronoConnectivity probably are the best extensions for forms and databases management.
I've found many tutorials (documents and videos) about CF but not about CC. This fact, in my opinion, penalize this good extension.

One of CC4 strategic functions is the multitable's relationship management, but i haven't found a tutorial about it.
So I only can ask here for having help.

My simple example: multitable relationship one-to-many.

Table A: “Teams” (Model ID: “teams” Connection app: “football” Forms app: “football”)
Fields: name, league, colors (ex. Real Madrid, Liga, White)

Table B: “Players” (Model ID: “players” Connection app: “football” Forms app: “football”)
Fields: team, name, position, number (ex Real Madrid, Ronaldo, Forward, 7)

For each team I have many players.
So I assume I must connect the field teams.name (Table A) to the field players.team (Table B).
I would like this result: when I click on team's name (in frontend list of table A) I see another page with all players of that team.

Obviously I don't need exactly this tables, but I need to understand what I have to set for this relationship.

This is the link with all the screenshots about this case. Can anybody help me to find correct settings?

https://dl.dropbox.com/u/4002624/OneToMany.pdf

Thanks.

Hi moto05,

I agree with you about the documentation, as I start to find my way around I'll write some more tutorials.

I think that you are talking about two different things here. If you want to click on a list in a team listing and see a player listing then you need to set up two different CC listings (or the second one could be a ChronoForms listing if it is simple).

You'd need a connected listing if, for example, you wanted to have a player listing and include some information about the team that was saved in the teams table. Building table JOINS can get quite complex and the first place to look is probably a MySQL tutorial on JOINs, with that understanding it would be easier to use the Multi-tables settings tab. I know it would be better if I could write an explanation but there is probably a day's work in writing that tutorial and I don't have a day to spare for it right now :-(

Bob

Hi GreyHead,

thank you for answer.

You'd need a connected if, for example, you wanted to have a player listing and include some information about the team that was saved in the teams table

.

It's exactly what I need.

I have to do an intranet Joomla site to manage police informations.

In particular I have a table for persons (Surname, first name, place and date of birth...) and a table for controls done on each person (date, hour and place on control, result of it...)

When I click on a record in the main table I need to see all the information about that person and the list of controls on him.

One person can have many controls (so one-to-many relationship).

I have done it in MS Access but now I have to export this system on an intranet site.

However I understand you haven't enough time to solve all the problems of each cc user. Thus I would like to find some guide or tutorial about similar cases.

Thank you,
Alex

Hi moto5,

I'd probably do this by using a ChronoForm to create the detailed listing and using a DB Record Loader to get the information on the individual plus a DB Multi-Record Loader to get the control info.

Otherwise I think that the answer is that you set up the main table on the CC General | General tab and then build the Join using the first block on the Multi Tables Settings block. The only catch is the you must specify a Model ID for each table - this is like the MySQL `tablename` AS xxx statement.

Bob