Hello Emanuele

Thank you for your purchase.

You probably misunderstood the feature. Foreign Keys are used to pull the values from another table's column when editing. The plugin cannot automatically pull the data from another column.

The only way you can do that would be to create an integer column, define values in it (1, 2, 3, 4, 5....), and then configure the relation to another column.

In that case, the way you connected the column (from your screenshot) will not work because you chose the same column to be the store and the display column. Store column should be an integer column to which the IDs you set will be linked to, and the display column will display the data of the chosen column from a row where the store column has an integer.

Hello Issac

With built-in features of the plugin, you have two options:

1. What you mentioned - create the relation, and add the values using drop-downs while editing the table.

2. Create an Excel table (for example), which will contain the IDs of all columns you want to change using the foreign key feature, like you did in the Order table example. Then, when you import that table, configure the relation, and all numerical values will be replaced with the values from the remote table.

Of course, you're welcome to use any custom solutions, but that doesn't fall under included support for the plugin. You can add it as a feature suggestion on this page, and hopefully our developers will be able to add it as a built-in option in one of our future updates.

Thanks for the suggestion, Issac, I will forward it to our development team.

We definitely have something similar planned for the future, but I can't say when it will be worked on. The idea is to pull data for an entire row based on one foreign key, but that will require a lot of coding hours, and testing, so I don't see this coming in the near future.