>>>>>>replace all myField with alltrim(myField) + padl(recno(),3,'0') in myView
>>>>>>
>>>>>
>>>>>hmm bu-bu-but its like i have four buttons and i want each one to grab the record it corresponds with.
>>>>>like the first button gets the first name and the second gets the name net but they all grab Ken.would i need a scan for that?
>>>>
>>>>I think you need first to learn how to formulate your problems the way others can understand them, especially since your native language in English.
>>>
>>>ok ok.
>>>i need to catch 4 values in a view or assign a button to the first four fields
>>
>>I give up, sorry. It would be too much time and effort involved to unweil your requirements.
>>
>>Just a helpful hint
>>
>>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