How can I display data in TDBAdvGrid which contains columns that from other table.

VCL TMS VCL UI Pack
1

I would like to have a grid which stored all the necessary ID such as Staff ID, Certificate ID and etc but I need to display the Staff Name instead of Staff ID which is stored in another master table (Staff Master). same case as Certificate ID that I need to display certificate name instead of cert id.

How can I refer to other table's field in the current table ? Is there any lookup field ?

2

?? Any updates ? Thanks

3

I would normally do this with datasets that have a lookup relationship between them and show the dataset in a TDBAdvGrid or the TMS FNC DataGrid