I'm using foreign keys in order to connect two table, I can show the information from the connected table, but once I change any column on the main table the connected column is zeroed "0" is inserted to the connected column.

I tried to create a manual table like in the youtube demos to check if something was different from my implementation, but I get error message trying to save configuration for the manual table I've created. Where and how can I see the errors/issues I've encounter to be able to fix them?

Hi, I found the situation nore clearly

 If you create foreign key connection, and instead of selecting all values, search only lets say 10 it will make the wrong assumtion and update the field with zero whenever you change any field on the row

If you select all row it works fine

latest 2.2.1 I think

Hi,

I've updated the version but still the same problem exists

I've created the situation on a site connected to the internet to show you my issue

http://www.malmial.co.il/Servers/

If you change the location by double click, you will be able to save the location as needed.

But, if you change the comment column or any other the location is becoming "0".

This happens as the table selected as foreign key is not loaded in full, I have a table where there are >500 objects in the foreign table so I want to use the search option and load only few a time.

If I will switch to load all it will work fine.

you can do that also in your sandbox

http://sandbox.wpdatatables.com/wp-admin/admin.php?page=wpdatatables-constructor&source&table_id=6

just change the table to inline edit and change any field other than employee or customer

Hi,

Is there any update regarding this issue?