>I am trying to make a query, that when found a specific type of record, I want to present all fields in textboxes... Some guy suggested to use the Scatter Function, but I dont know how to use it. Plz I will be very grateful for some help.
>
>I have someghing like this.. but does not work:
>
>Select * from proyecto ;
>where tipomed = m.type_p ;
>and numero = m.numero ;
>Into cursor ResultSet
>Scatter Name to
>m.tipomed
>m.numero
>m.descripcion
>m.resumen
>m.resumen2
>
>it gives me this errors:
>numero is not an object
>descripcion is not an object
>bla bla bla
>
>att. Juan

If you just want to store the values of the fields in textboxes:

Select * from proyecto ;
      where tipomed = m.type_p and numero = m.numero ;
Into cursor ResultSet

thisfirm.text1.Value = ResultSet.Field1
thisfirm.text2.Value = ResultSet.Field2
etc.

Is that what you want?

By the way see SCATTER in help, you can use it:

SCATTER NAME oFields
? oFields.Field1 && The name of the field must be in place of Field1
? oFields.Field2
etc.