Query/Grid/ActiveX Question

[mns117]

Hi! I am building a system in which the user can search for a string in specific fields. The user will chosse the field to look in, type in the string and hit search. I am using a query to find the string in the specific field. I am sending the results to a cursor. Now here's the tricky part...

I am using the cursor as my datasource for a grid. This will allow the user to look at all the results, decide which one they were looking for, then view a .pdf for that record. Basically each record is a bibliographical reference, so the user will be viewing an actual journal.

Now if I include the general field in the query the query can take forever because a query that has many results will be copying a large amount of .pdf's too.

I want the user to be able to click on the reference in the grid which would highlight it and select it, then click on either an OLE Bound Control or a button to open Adobe Acrobat to view the .pdf. Is there anyway to do this without using a general field? If there isn't how about an easy way to reference the general field in the original table without acutally having to query that field.

Any help is greatly appreciated.

Thanks. Mike

 

[chpicker]

Do you have a primary key on the original table? If so, set the table ORDER to that key, set a RELATION from the query table to the original table, and you can just use the original General field.

Of course, a simple SEEK when the user wants to view the journal would work as well. That way you don't have to use a RELATION.

Hope that helps,

Ian

 

[ramani]

HI
How about having the query in a view and the view having whatever fields you want except the General field. whenever the user selects a record in the view.. obviously you get the key value.. seek that record in your real table and view your general field thru whatever activex or your choice.. may be an explorer activex (webbrowser4 ?) .or. internet explorer application instatioated.

Hope the idea helps you ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com