How to Create a Table or View of Multiple Tables, that can be edited from Front-end?
For example:
how to make a Table that shows the data other three tables and that can be edited from Front-end?
How Connect the data of two tables through their relations with a third table?, but this third table can be edited from Front-end?
If you take a look at our documentation you will see this notice
Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currenlty is no way to update multiple tables – but this problem is being investigated and pursued.
Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” pagecan be edited.
Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.
MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.
Hi OscarJPaniagua,
Thank you for your purchase.
If you take a look at our documentation you will see this notice
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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