>I want to show a list of two different fields as one column in a dropdown list box.
>
>Example:
>Recno, Field1, Field2
>1 AB ZA
>2 AC ZB
>3 AD ZC
>
>List Box needs to show the two fields as one column:
>AB
>AC
>AD
>ZA
>ZB
>ZC
>
>User selects ZA or AB and goes to record #1.
>
>How can this be accomplished?
Hi Rixon,
Try:
SELECT FIELD1 AS MYFIELD, RECNO() AS REC_NUM;
FROM Mytable;
UNION ALL (SELECT FIELD2 AS MYFIELD, RECNO() AS REC_NUM;
FROM Mytable);
ORDER BY 1;
INTO CURSOR Foo
hth,
George
Ubi caritas et amor, deus ibi est