Hi Robert

>SELECT *;
> FROM ;
> dbo.Equipment Equipment
>
>and it works fine.

Yep, that'll do it. Actually, if you were to dump out the view programmatically (using GenDBC) you'd see the settings that VFP puts in for this sort of thing and then you could code the views directly.

>Regards to Marcia.

Will pass them on. Off to Frankfurt for the European DevCon on Friday, so may not be around here much over the next few days...