I changed the field name to descrip from desc and everything seem to work again as advertised. Seems VFP likes to go for a loop every now and then and cause havoc.

Mental note to everyone...do not name field names reserverd words in VFP ever.

Thanks.


>
>Seems to me may be the field name "desc" makes the trouble (desc is a reserved word in VFP) - play around with the AS clause to rename the field in the view and/or in the base table