I hace one table called "Project" and another called "Users".
So, the table calle project has responsables and approvers, but those field are both liked into the "Users" Table. Is it possible to use a foraing key linking those two field to the same "Users" table? Or do i have to have one "User" table for every field?
Correct me if I am wrong. You have table "Project" with columns responsables and approvers and you want to be linked with colum (for examle user_last_name) from Users table?
If the answer is yes, then its possible. For every column(responsables and approvers) you have to choose table Users, set the "Display value"(column from Users table that you want to be shown) and the end "Store value" ( choose which column values will be stored in the table for reference - by default wdt_ID, or ID)
Hello,
I hace one table called "Project" and another called "Users".
So, the table calle project has responsables and approvers, but those field are both liked into the "Users" Table. Is it possible to use a foraing key linking those two field to the same "Users" table? Or do i have to have one "User" table for every field?
Hi mcacciavillani,
Thank you for you purchase.
Correct me if I am wrong. You have table "Project" with columns responsables and approvers and you want to be linked with colum (for examle user_last_name) from Users table?
If the answer is yes, then its possible. For every column(responsables and approvers) you have to choose table Users, set the "Display value"(column from Users table that you want to be shown) and the end "Store value" ( choose which column values will be stored in the table for reference - by default wdt_ID, or ID)
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