Miles,
You need to have a UNION joining the two parts of the view. Test it in a PRG until you get a cursor you want, then use that code to create your view. Don't forget that with a UNION you need exactly the same field structure in both parts.

HTH
Barbara

>Please have a look at the lines marked with "$". VFP returned the error "This type of query not allowed" when I tried to open the view. Does that refere to the subquery?
>Is this type of subquery allowed in views in 6.0?
>
>Thanks - Miles Thompson
>

>create sql view lv_intcalcsource as ;
>select InvHead.cinvoi_key, ;
>	     <snip>
>	InvHead.cPenRevAcc ;
> from hea!InvHead inner join hea!Company ;
>   on  InvHead.cCompa_Key = Company.cCompa_Key ;
> where ;
>    ( DaysToPaid() > IntCalc.ic_days .and. .not. lFullyPaid ) ;
>     .or. ;
>    ( lFullyPaid .and. ;
>      ceiling( (DaysToPaid() - IntCalc.ic_days) / 30 ) + 1 > ;
>$        (select count(*) ;
>$             from InterestDetails ;
>$             where InvHead.cInvoi_Key = cDet_InvoiKey) ) ;
>  order by Company.cCompanyName, InvHead.dCompletionDate