when trying to define one column as a foreign key to different table, it works fine.
But if I'm trying to define second column in that table as a foreign key, I can't make it working. The second value is still visible as "integer", not as a display value from another table.
Is it possible to define multiple foreign keys in the single table please?
Hello I have the same problem. The first foraing key works good, but the second one that i try to do (Using the same referenced table) does not work. Any solution Petrok?
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me on tables id which you use to do this.
Hi,
when trying to define one column as a foreign key to different table, it works fine.
But if I'm trying to define second column in that table as a foreign key, I can't make it working. The second value is still visible as "integer", not as a display value from another table.
Is it possible to define multiple foreign keys in the single table please?
Hi Petkor5,
Thank you for your purchase.
Yes you can. My suggestion is to look up in our documentation about foreign keys on this link.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hello I have the same problem. The first foraing key works good, but the second one that i try to do (Using the same referenced table) does not work. Any solution Petrok?
Sincerely,
Hi Milan,
it's not working for me. I can define only one foreign key per table.
This is a serious issue, since our data model requires more foreign keys per table.
The steps I'm trying to do:
1. Create a new table
2. Create fields like: Title (one line string), Reference1 (integer), Reference2 (integer), Reference3 (integer)
3. Create one record with some default values (like "1" in every integer field)
4. Step by step change every integer field to string, select "use value from another wpdatatable" and select different table for each field.
As a result only one foreign key field is working....for the others I still see only integer value, not the display value from referenced table....
Hi Petkor5,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me on tables id which you use to do this.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables