Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #1337826
Multiple Foreing Keys
Closed

Comments

  • mcacciavillani started the conversation
    October 17, 2017 at 5:48pm

    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?

  •  472
    Isidora replied
    October 18, 2017 at 10:39am

    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