>>>>Take a look at
>>>>
>>>>SELECT-SQL command in Help.
>>>Oh ohhh...you dont understand what i mean?
>>
>>
>>ok ok if you have a table with three names how would you get them to show simultaneously in 3 text boxes
>
>One last time.
>
>select T1.Name as Name1, T2.Name as Name2, T3.Name as Name3 from Table T1, Table T2, Table T3 where T1.ID = 1 and T2.ID = 2 and T3.ID = 3
>
>quick, though not very efficient way.

so so so how bout an array to save them to a table.

SELECT bookid FROM mainbase!v_library WHERE booktype<>"B" INTO ARRAY lb

how do i write this back to the table

replace bname.first1 with " "
replace bname.first2 with " "

?