>>>>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.
If it's not broken, fix it until it is.
My Blog