>Select Invoice1
>seek lcInvoiceNo
>sele Invoice2
>seek lcInvoiceNo
>thisform.grdbase1.refresh()

Rixon,

First I want to say that it may take you and hour to get used to using a parameterized view and it may take you days to sort out why the present method is failing. The choice is yours.

In the code snippet above you are first selecting the Invoice1 alias and moving the record pointer, you then select Invoice2 and move its record pointer. Selecitn Invoice2 suspends the relationship from Invoice1. If you have a relationship in place then there is no need to select invoice2 and move its record pointer as it will moved by the relationship.

With a parameterized view the code would be;

lcInvoiceNo = TheOneYouWant
Requery(YourViewOfInvoice2)
Thisform.grid1.refresh()