Hi Marcelo,
Is the view in your grid a parameterized view? It should be, using the id_client field (I'm assuming this links the two tables) as the parameter.

Make a form method that sets the view parameter to the id_client value in your combo and then requeries the grid. Call this method in the combo interactivechange method, and also in your form's init so the grid is properly refreshed for the first record. Assuming that (1) id_client links the tables, (2) that mID_Client is the view parameter and that (3) ID_Client is also the bound value of your combo, your method would be similar to this:

mID_Client = thisform.MyCombo.value
ClientView.Requery()
thisform.Mygrid.refresh()

Yes, using NoDataOnLoad is a good idea here.

HTH
Barbara


>Hi all,
>
>How can I display in a grid all the payments referred to a particular client ?I have a combobox and a grid in my form.There are two tables, one of them with Address,LastName,FirstName and so on... and the other fields like payment_date, type_of_payment etc.Both tables are relationed.The RowSource of my combo have the following code :
>
>Select allt(LastName)+","+allt(FirstName),id_client from mytable order by LastName into cursor cNames.
>
>1)Now, what code should I put in the interactivechange of my combo if my grid is based on a view ?
>2)Should I put DataOnLoad to .F. in Form´s Init()?
>
>Thanks for your help.