I am embarking on unknown territory in creating a VFP front for a rather large Oracle database.

When my form opens, I want it to be blank, and the user will then select one of four fields as criteria for a query. Then the query is sent to the database and retrieves one record for updating. The one record is fields from 8 or 9 tables with verious join conditions and is structured in a rather complicated view. several of the fields will be modifiable by the user and then I want to update the database with the additional or updated data.

I use noDataOnLoad, and do not retrieve data until the query runs. In a VFP database I would have the four fields indexed and do a seek to locate the appropiate record. But views are not indexed, so must I somehow invoke the ORACLE index and search for the matching field, before executing the query?

The question is how to retrieve that record without having to scan all these tables? I guess I am spoiled by indexdeek()