>>>>How want to know the RECNO() in a TABLE from a
>>>>VIEW created from that TABLE?
>>>
>>>You don't. You need to create a unique ID field.
>>>
>>>Tom
>>
>>Hi Tom... I am using a BROWSE after a SQL VIEW and when I pick a record
>>in the BROWSE and then leave the BROWSE, I want that record to be
>>my current record when I return to my table (not my view).. So I thought I would capture the recno() from the BROWSE, but that does not always work, cause the recno() is that of the VIEW.
>>
>>
>>Help
>
>You need to find a field value that is unigue to each record and use that. RecNo() will not do you any good.
>
>Tom
OK good.. how do I use my unigue field to return back. code please.
ex. if unigue is IDNUMBER, do I
SELECT TABLE
SEEK myview->IDNUMBER
This is old way - is there something else in vfp OOP
Rob