In the command window, you needed do each one separately, or you could highlight all three commands (4 lines?) and then press enter.

So the query does not work. Let's eliminate a variable (try in command window)

Select * from InvoiceDetail Where Invoice_ID = 31984

Your results will pop right up in a browse window...does it work? If it doesn't, you need to look at the invoiceDetail table and make sure it has data for this invoice_ID in it.


>Sorry guy, I lied to you earlier.
>I see now that I did a cut and past of all your earlier commands into the command window and it only performed the last line that was "Browse". What I saw was the Product file. As soone as I noticed that the Product_ID was right, I thought all the code ran. The pointer was there because of the IndexSeek command I tried on the Product file that came back true put it there.
>
>Now that I do the three lines of code one at a time I get the InvLinesCursor table open and it is blank. New hmmmm.
>
>Based on that, should I still try this code?
>