cc4 v cc5 model

Hoping you can provide guidance...

I have 4 tables to join. Table P, Table O, Table U, and Table A.

Table P is main table.
Table O connects to P
Table U connect to O
Table A connects to O

I have all assigned as relationship "belongs to"

I'm able to get the first three tables working fine. It's the last one that I can't figure out.

In cc4 the join rule was in the format 'o.order_user_id=a.address_user_id'. How should this be put in cc5?
[attachment=0]cc_model_question.png[/attachment]

I have adjusted the table setup.

P is main table
O belongs to P
U belongs to O
A belongs to U

I can connect the first 3 tables. Great. When I connect the 4th table, I get warnings. Can you direct me on how to fix the issue?

[attachment=0]cc_model_warnings.png[/attachment]

Any help? I'm at a complete loss :?

...I have the models setup exactly as I did in CC4. However, whenever I add the 4th table in cc5, I get admin component errors (listed above).

Figured it out🙂

Hello mduda,

Can you share how you figured it out? I'm having issues with joins in CC5.

Thanks.

Hi Chris,

I'm not sure what exactly you are having trouble with, but for me it was two things:
[list=]Join Rule
Foreign Key[/list]

In cc4, you didn't have to use php format. In cc5 you need to add it...

As for the Foreign Keys, I had it mixed up.