Input field with value from another datatable

sesimon

I am pkanning to set up a small project with the editor but one field has to be filled with a value from another datatable.

E.g. ... I have table orders having general data about an order but i want to fill client data from table clients ...

So I create row in orders having a coloumn client id. When clicking on client id a popup comes up with a datatables on client table where user can search for client and selected value returns client id to editor in client id column.

how do i do that?

Regards,

Sebastian

kthorngren

Does this example answer your questions?
https://editor.datatables.net/examples/advanced/deepObjects.html

Kevin

allan

Sounds like a perfect use case for joined tables on the server-side. Here is an example.

Regards,
Allan