Make Grid column data combo with data from diff. table

Suite and Optimus Suite 5
#1

I am populating a grid with data from one table in DB and I want one column (status) to be of a type combo (coro) but with data from a different table so user can update the status. In the screen shot the status column is combo (set as coro) but the data is from the same table and I want that data to come from another table in the form of combo data (as shown in the screeshot combo2). Is it possible to achieve this? if so any sample code is appreciated - Thank you!



#2

If your are populating the data to the grid using the dhtmlxConnector functionality you may try to use the optionsConnector to generate options for your coro column:
docs.dhtmlx.com/connector__php_ … ector.html

#3

Thank you very much for the pointer!

#4

Is it possible to populate grids cells where data for each cell is from a different table using OptionsConnector?
For example
cell a from table a
cell b from table b
etc…

it worked fine when I loaded the grid from xml file with coro options and the data was saved in the database however the grid will still be using the same xml which defeated the my purpose of using the coro feature.

Thank you!

#5

Any expert out there to answer my question?