>I am working in the detail area of an invoice module. I have three tables I am working with: InvHead, InvDetail, and Inventory. InvHead is related to InvDetail by InvNo; InvDetail is related to Inventory by PartNo. (Sound familiar??) The invoice head to invoice detail is working OK, but I can't get the part # to behave:
>
>A. If I SEEK the txtPartNo.Value IN Inventory, it flushes the buffer (Buffering = 5) so I cannot TABLEREVERT() and, when I try to input the quantity, I get a Record is in use by another user error message. (I am on a stand-alone computer.)
>
>B. If I do not SEEK, the quantity and TABLEREVERT() behave, but I get the wrong inventory description and price.
>
>I am verifying the existence of the Part # in a separate class (oInvoice.FindItem) with another copy of Inventory. That works fine; however, I have to move the pointer in the copy of Inventory that the form has open. How can I accomplish that without flushing the buffers????
>
>TIA.
>
>John
John, check the relations set in the DataEnvironment (and in other places like LOAD() ). If you are using Inventory as a lookup-file for PartNo and Part Desc., then you might want to load them as read-only. If you don't set ANY relations, then the SEEK should work. Also, since Inventory isn't changing, your buffer flushing should have no effect. Sounds like the pointer on InvHead or InvItem is moving.
HTH
Barbara