Grid with Relational database

Hello,

As I’m using the relational database structure, most of the fields in the table have numeric values pointint to a value in a different table. But I also have numeric fields getting the result from static data eg 1=Yes, 0=No

How I can display in the grid these values, but most important how the filtering droplists will have also these values.

Thank you
Christos

most of the fields in the table have numeric values pointint to a value in a different table.
If I undrestood you correctly you can easily use any math in the grid:
docs.dhtmlx.com/doku.php?id=dhtm … th_in_grid

I have numeric fields getting the result from static data eg 1=Yes, 0=No
You may try to use checkboxes.

Can you explain the core framework of relational database? What about defining integrity constraints to manage data in grids?