I want to display a table shows the appointment and I want to add new column called "Driver". I want to assign a driver to each appointment from the drivers table. how can I do that ?
I added new column to the appointment table and when I selected the type to "one-line selectbox" the "possible value field" I want to get it from the drivers table, specifically "driver name" field
I believe you want to take a look at the Foreign Keys. In an example we've shown on that page, you can see how you can create relations like this. There's even a downloadable DB with tables from which you can replicate the tables in the documentation, just to see how it looks and feels when you use the foreign keys.
Hi,
I want to display a table shows the appointment and I want to add new column called "Driver". I want to assign a driver to each appointment from the drivers table. how can I do that ?
I added new column to the appointment table and when I selected the type to "one-line selectbox" the "possible value field" I want to get it from the drivers table, specifically "driver name" field
Hello Ayman.
Thank you for your purchase.
I believe you want to take a look at the Foreign Keys. In an example we've shown on that page, you can see how you can create relations like this. There's even a downloadable DB with tables from which you can replicate the tables in the documentation, just to see how it looks and feels when you use the foreign keys.
Please go through it and let me know if it helps.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables