Neil

Further to Hilmar's suggestion, I'd recommend using the view. You can "pretend" it's just a table, though it encompasses more than one. You can put the view in the DE, make it the source of the grid.

As Hilmar says, check the "Send SQL Updates" box in the view builder.

One more thing: you said that the SQL query happens when you press a button. For this reason, I think you have to set the "NoDataOnLoad" property of the view, in the DE, to .T., meaning that the view won't be filled when the form opens (how would it necessarily know what criteria you're using at start-up anyway?).

When you click the button that would otherwise fire your SQL you, instead, issue =REQUERY( "lvMyViewName"), to fill the grid with the required data.

HTH

Terry

>Hi John
>
>When I initialise my form it basically does the SQL into the cursor. How would I incorporate this on the form / local view. Havent used this method before??
>
>Thanks