5 tables connection

Hi,
the problem is always tied to the pk, but how?

I have 5 models corresponding to 5 joined tables through inner join.
(see attachment)

I would understand if:

1. the model containing the pk to be the first;
2 I make searchable fields of the model-4 and model-5 I get error Unknown column in 1054, while it works perfectly on other models

I would like to set the research fields on all models (tables)

thanks a lot

Hi Camelio,

I have created a new topic, because this question is not related to the other topic.

Normally if the 5 tables are joined using an inner join then the search should work fine, please leave the "Fields" boxes empty in all your models settings.

Regards,
Max