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
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
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
This topic is locked and no more replies can be posted.