I have a form which has a DBGrid and a whole bunch of other components like DBEdit, DBRadioGroup, DBLookUpComboBox and DBComboBox. All these components point to the same table in the Database. As you select different records in the Grid, all the components get the corresponding values.
The DBComboBox1 points to the field 'Report' in the table. The field 'Report' is an integer field and currently only have the values 0,1 and 4. 0 stands for Reportdisabled, 1 stands for ReportEnabled and 4 stands for ReportInsiteonly.
I can get the DBComboBox1 to display 0,1 and 4. I can also click on the dropdown, select a different value and it is saved to that particular field.
1) What I want to do is for the DBComboBox1 to display Reportdisabled, ReportEnabled and ReportInsiteonly instead of 0,1 and 4?
2) Also when I select lets say 'ReportEnabled', It should save 1 in the field for that particular record?
I might have put in a little too much explaination, but I hope it helps understanding the question.