Hi Mike,

I had to write a find form which users could search our browse lists with. If you could select out the fields into a cursor you could then search the cursor. This is basically what I done, scan through each column looking for values.

I dont know if this is the sort of thing you are looking for but I may be able to give you a little more info if you want.

Jon

>Hi Simon
>
>Many thanks for your reply. The answer is no, I don't have it sorted yet.
>
>What I want to do is to allow a list of fields to be searched to be displayed. This list would not include the secure data, as it is intended only for operators.
>
>What I have is certain databases, for instance our customer database, which contains fields named code,company,contact,salutation,ad1,ad2,ad3,ad4,postcode,country,phone,fax,email. There are other fields which I don't want operators to be able to see, so I don't even want them on the list. In a program, I want to be able to specify the fields, such as in the Foxpro for DOS version 2.6 where you can say 'browse fields code:R:H='Customer Code,;' etc having defined an appropriate window. In version 2.6, we can do this and use Control-F to do a search, which was actually very friendly and does precisely what I want, as I can then have an additional F Key to scatter memvar, go back to quotation file, and gather the memvar, hence filling in customers name and address.
>
>I am trying to convert the 2.6 project to Visual. I wrote the 2.6 project, and am struggling with the conversion, as the idea is to make the project as similar to the DOS version as possible in terms of operational sequence and keys. Obviously it will look very different.
>
>I have total access to everything, and can create as many indexes as I want, and this is not a problem.
>
>I hope this explains my problem. Essentially I need a Control F sort of function within a form where I have specified the fields I want operators to see, and can put appropriate column headers etc using the standard form generator in Visual. There are times when I need the form to be modal, and the standard classes seem only to work in modeless forms.
>
>Hope I haven't confused you.
>
>Best regards
>
>Mike Johnson