>Hello,
>
>In a form's DE I have a table and a child table like Company and Street, while the Company.StrId is linked to Street.StrId. On a combobox the streetname should be displayed, and can be changed using the combobox as well.
>
>Normally I do the update of the Company.StrId in the save method (like Replace Company.StrId WITH Street.StrId), and I do not bind the combobox to a data field, because it never seems to work (the Combobox shows the Street.Description). But I think there must be an easier way, and maybe somebody can explain me how to do this.
The combobox can be bound to a field other than the one displayed, e.g.,
With thisform.cboStreet
.ControlSource = "company.strid"
.RowSourceType = 6 && fields
.RowSource = "street.description,strid"
.BoundColumn = 2 && strid
.BoundTo = .T. && if strid is numeric, if not, doesn't matter
.ColumnCount = 1 && shows only the first field when the combo is dropped
EndWith
>
>Thanks for you help (and best wishes for the new year to all!)
Insanity: Doing the same thing over and over and expecting different results.