TDBAdvGrid and multiple tables

Krishnamoorthy_Rangarajan · April 19, 2015, 4:59pm

Hi,

I am able to map a DBGrid to a single table quite easily and it works fine. Now I want to add an extra column to the grid, but map its values to the values of a different table (using a foreign key). Also, each cell of this column must be a drop-down box with values that are check boxes (corresponding to values from the other table). Is this possible? I would appreciate some hints to get started.

Regards,

Rangarajan

brunofierens · April 19, 2015, 6:37pm

TDBAdvGrid displays the fields as defined in the dataset connected to the grid. So, you'd need to map these extra fields in your dataset. With respect to dropdown controls as inplace editors, every lookup field in the dataset will be edited via a dropdown. See demo ADOLookup that demonstrates this.