| Category | Data Query |
| Default Catalog | Visual FoxPro Catalog\Foundation Classes\Data Query |
| Class | _cbolookup |
| Base Class | ComboBox |
| Class Library | _dataquery.vcx |
| Parent Class | _combobox |
| Sample | ...\Samples\Vfp98\Solution\Ffc\datalook2.scx |
Remarks
This class performs a lookup of values in a field to populate a combobox.
To use, drop the class on a project or form or, from the Component Gallery Item Shortcut menu, select Add to Form. When you add the class to a form, Visual FoxPro opens a builder so you can specify the appropriate Lookup_table, Order_column, Display_column, and Return_column values. When you drop the class on a project, you can choose between adding the class or creating a subclass.
See Guidelines for Using Visual FoxPro Foundation Classes for more information on using foundation classes.
| Properties, Events, Methods | Description |
| Display_column property | Specifies the column value from the Lookup_table to display in the drop-down list. Default: "" |
| Lookup_table property | Specifies the table in which to find the column containing the values to display in the drop down list. Default: "" |
| Return_column property | Specifies the column value (0, 1 or 2) to return to the value property of the combo box. Default: "" |
| Order_column property | Specifies the column to order the records displayed in the drop down list (optional). Default: "" |