Hi Alex,

i did not fully understand all the details of this use case, and what functionality is expected from our Plugin.

 For example, if you mean to make a "one to many" foreign key relation with our Plugin,

at the moment, that is not possible.

We do have a foreign key relation column feature ( please check more on it here),

but it it limited to just one-to-one relation, so each value needs to be unique coming from the remote table.

You can have editing of Foreign Key Column(s) with a single value selectbox.

-

So, for example if the Column "Name" is in the child Table, 

 you can make the foreign Key relation "Parent" column

that pulls values from a remote table for "Parents".

Then the editing will be possible as unique values for the parent from the other table.

I hope that makes sense, let me know if that can work for your use case.

Thank you.

Hi Alex,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I am sorry, i thought you had two tables and are making a foreign key relation on them;

But now i can see what you mean.

If you want to have all this in one Table,

and add a new Column - which is going to pull all the available values that another column has;

That is not possible;

You will have two possible workarounds for this :

1. You can make a separate table which will hold all possible values for the names you need,

and then make a foreign key relation to pull values for editing from there;

( please check our example how this works here)

2. Or, you can manually add values which will be available for editing checkbox,

like this :

In the Column Data tab, set Possible values for column  to Define Values List,

then manually add values available for editing in the dropdown :

At the moment, that is the only way,

because in order for the foreign Key Column to pull available values from another Column,

that Foreign Table needs to have a unique row ID column of its own ( for example in the Parents Table it can be called "ParentID" , or just "ID",

but in this table,  it also has to have another "row ID", if that makes sense - for our Manual tables we automatically add column named "wdt_ID" which is a primary unique auto increment integer, for Editing);

,

so each name value has a unique ID,  in order to be pulled,

while this editing table you are using also needs to have it's own unique Table row ID.

Let me know if anything is unclear.

Thanks.