I have a column in a grid which is supposed to show the vendor_name for the corresponding vendor_number. The tables are related properly, but the entire column shows the same vendor_name, even though each record has a different vendor_number.

column1.bound=.f.
column1.currentcontrol='vendno'
column1.controlsource='vend.name'
column1.sparse=.t.

column1.text1.controlsource='vend.name'
column1.text1.readonly=.t.

column1.vendno.controlsource='items.vendno'


Table items is related to table vend via the vendno field.

Please help me understand this.