Hi

I build CRUD web apps and got a lead for a MS Access system that the client wants redeveloped in PHP (WordPress). I usually use datatables.net editor version but seeing that this project is for WordPress, I stumbled upon your plugin, which i think is a masterpiece BTW. 

The question here is, can the plugin support relational database tables or will custom work need to be done? E.g. they have a worksheet table which lists all the jobs. This tables has a form that is used as a job card with the details of the job, which is linked to a client table, engineers table etc, so its a system that they use to run their repair workshop.

I can easily build the tables and system using your plugin, but I will need to link the tables so that data is updated across the board. Say I change a clients telephone number, it must display on the job card as well as its pulled from the client table, obviously. Or is all this done on database level and the plugin will display it accordingly?

Also, to trigger emails on certain actions, do you have a developer resource or API?

Please advise and thanks in advance.