>>>As for using a cursor or table as the RowSource for my combo, I am only trying to display a list of item codes and item descriptions. If I use a table (as opposed to a cursor), I can still control the order of the fields displayed in my combo's list using depending the RowSource property. e.g. RowSource=Lookup.field1, field2 vs RowSource=Lookup.field2,field1. Maybe I'm not understanding something ? - which is happening a lot as I learn VFP :)
>>
>>If you're using RowSourceType = 6, then you can specify fields you want in the order you want. If you're using Alias as a RowSourceType (2), then the fields will be in the exact same order as they are in the table, which is RowSource. So, it looks like RowSourceType = 6 is the answer. And that's why if we want to use RowSourceType = 2 (alias) we need to have fields in the table in the order we need. That's why we may want to use select statement to create a cursor.
>>
>>The question is - why do we need to go this troublesome route if RowSourceType = 6 will give us the result we want? And I'm not certain in the answer to this question <g>
>
>Thanks Naomi! I feel better that at least I'm asking good questions :)
>
>Maybe someone else can shed some light?
I hope someone can join this thread to answer OUR questions <g>
If it's not broken, fix it until it is.
My Blog