Combo Box - Compound Record Source

[OldBitByter]

I have a combo box (cmbClient) that has the following:

BoundColumn - 1
BoundTo - .F.
Column Count - 2
DisplayValue - cmbClient
FirstElement - 1
RowSource - chart.n_client_id,n_vol_id
RowSourceType- 6 - fields

It seems to work ok except I can't get the vol_id to display in the box. It shows on the drop list, but once selected in the list, the display only shows the first column. This part is ok except that I can't always count on using the list to get the correct record. I must sometimes enter the id numbers from a scanner or by typing in the numbers. I can't seem to be able to get a list item selected by typing the client_id/vol_id in the box. I have to be able to enter both in the box and have the correct record pulled up.

Any suggestions?

 

[rgbean]

Try,


BoundColumn - 2
RowSource - chart.n_client_id+n_vol_id, n_client_id, n_vol_id

Rick