>I am trying, without success, to use the Rowsource property of the standard list box in visual foxpro 5.0 and have 2 columns populated, only the first needs to be visable.
>
>Property Assignments being used are:
>
>.ColumnCount = 2
>.RowSourceType = 2 && Alias -- Was 6 - fields
>.RowSource = 'AllTrim(' + lcPrefix + This.mcSourceTable + "." + Field(1) + lcSuffix + ' )' + Chr(9) + This.mcSourceTable + '.Seq_num'
>
>
>This works without error but the separator, Chr(9), doesn't seem to have any effect. I can't see anything in my second column. I have tried this same statement with the alias-2 and field-6 Rowsource property types with the same results. If I replace the Chr(9) with a comma I get a field reference error ( "field" phrase is not found (Error 1130) ).
>
>Does anyone have any idea or sulution ????


You should only specify your table alias on the firt field of your row source, such as table.field1,field2,field3.