I have a table with people's name. Esentially, it has and ID and NAME field. Another table is related to the first one thorugh the ID field as a foreign key.
When updating the second table, I would like to have SELECT field which takes all NAME's values from the first table in order to choose one of them.
Maybe you can create MySQL View where you will join these two tables to accomplish this or maybe to use tables without server-side processing turned on. I think that there is no wpDataTable filter or action that you will use to accomplish that. Something like that requires custom coding.
Hello:
I have a table with people's name. Esentially, it has and ID and NAME field. Another table is related to the first one thorugh the ID field as a foreign key.
When updating the second table, I would like to have SELECT field which takes all NAME's values from the first table in order to choose one of them.
Could this be possible? What filter should I use?
Thanks.
Hi raperez,
Thank you for your purchase
Maybe you can create MySQL View where you will join these two tables to accomplish this or maybe to use tables without server-side processing turned on. I think that there is no wpDataTable filter or action that you will use to accomplish that. Something like that requires custom coding.