>I have a combo box that is linking improperly or so it seems. I have done this a thousand times but this one just won't link properly..
>
>Row source is Lookupdata.description
>Row source type is Alias
>
>Controlsource is master.id
>
>interactive change updates master.id with lookupdata.id.
>
>Report links fine but form shows different description.
>
>I have both tables in the data environment of the form and link master.id to lookupdata.id
>
>This is driving me and my users crazy. I have other combo's on this page that works fine.
>
>What could I be missing?
Make RowSourceType = 6 && Fields
RowSource = [Lookupdata.description, Id]
ColumnCount = 2
BoundColumn = 2
BoundTo = .t.
Controlsource = [master.id]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.