>>>>with Rowsourcetype = 6 you can choice the column order of the fields
>>>>
>>>>with Rowsourcetype = 5 you cannot.
>>>>
>>>>then you need 1 array for every different 6 fields order column,
>>>>it is not need an array for every combobox.
>>>>
>>>>profit 1, profit2, etc. 1 array
>>>>
>>>>profit 2, profit1, etc. 2th array
>>>
>>>I'm guessing I may just try it. In the meantime I asked, if this is something we want to implement or just showing this item will be enough. Once I get the answer on this question I know if I need to program or not...
>>
>>good luck
>
>I got a weird error when I tried to implement it and now I'm stuck :(
>
>I've created the array as a property of a container class I instantiate in run-time for that page. I have
>
>SELECT * FROM prof_ctr INTO ARRAY this.arrProfitCenters
>this.pc_Combo1.RowSourceType = 5
>this.PC_Combo1.RowSource = 'this.arrProfitCenters'
>
>
>and the 3 line of this code is giving an error - property arrProfitCenters is not found. Why is that?
in RowSource, this.arrProfitCenters is evaluate to this.pc_Combo1.arrProfitCenters
you can change the design with
pc_Combo1.RowSourceType = 0
PC_Combo1.RowSource = "this.Parent.arrProfitCenters"
SELECT * FROM prof_ctr INTO ARRAY this.arrProfitCenters
this.pc_Combo1.RowSourceType = 5