>>>>>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
You can also Set Relationships either visually or through code.
Tom