Hi Jose,

Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.

Thank you for your understanding.

I am sorry to disappoint you, but this is not possible with any of our current Plugin's capabilities.

At the moment, it is as you found - our Foreign Key Column feature can only work for a 1 to 1 relation.

In your use-case, you need a more 'custom' relation which is something like " 1 to many" relation.

It is not possible to achieve that with our Foreign Key Built-in feature, since you can only choose 1 Store Value and 1 Display Value.

This is why we have that limited to a "Single Value selectbox", while for some other editable Columns ( which are not Foreign Key)  you can have "multiSelectBox".

At this time, we don't have a built-in feature to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

2. If you use SQL JOIN function in our SQL Tables - you will not be able to edit that data.

As we pointed out in this Editing Documentation.