A typical use of combo box in VFP is to let the user select an item from a list and store the ID of the selected item in the foreign key of another table.

For example a Customers table has two fields Cust_Id and Cust_Name. The user selects a Customer Name from the combo box containing the names of the customers and the relevant Cust_Id is dtored in the foreign key (say, Cust_Id) of the current record of a child table Bills.

This works fine as far as the combo box is contained in the form itself. But if you try to use it in a grid whose RecordSource is the Bills Table, the combo box does not behave as intended. When the focus is on the cell containing the combo box, it shows the Customer Name. But as soon as the focus is moved to another cell, the combo box shows the Cust_Id instead of the Customer Name.

Please help!
Anil Dharampal