>Hello All,
>
>I want to select the last+first name using a ComboBox. The problem is
>how to get the Last+First names (combintion) into an array as one field. Is creating a field in the record that contains both, creating an index for it and bringing it into the array, or referrencing it directly, the best way? TIA.
>
>Regards,
>
>Paige
Paige,
try this
Select alltrim(fname)+' '+alltrim(lname) ;
from mytable ;
into array thisform.YourArray
then set your combo RowSource to the array
Regards
Pete Kane
Regards,
Peter J. Kane
Pete