>Gregory
>
>Thanks for your help, my code now looks like:
>
>sele a.RegionID, b.RegionName from lvRequirementBooking1RequirementList1 a ;
> join lvRequirementBooking1RequirementRegionMaster1 b on (a.RegionID = b.RegionID) ;
> where .T. group by a.RegionID order by b.RegionName into cursor lvRequirementBooking1RequirementFilterRegion1
>
>This gives me a list of all Regions that appear in my lvRequirementBooking1RequirementList1 table. If I wanted to add a record called "All Regions" to the cursor lvRequirementBooking1RequirementFilterRegion1, how would I go about that?
>
>Regards

select a.RegionID, b.RegionName from lvRequirementBooking1RequirementList1 a ;
    join lvRequirementBooking1RequirementRegionMaster1 b on (a.RegionID = b.RegionID) ;
    where .T. group by a.RegionID order by b.RegionName 
union all
 select distinct cast(0 as I) as RegionID, 'All Regions' as RegionName ;
from lvRequirementBooking1RequirementList1 
 where RegionID = 'Some Existing Region'
into cursor lvRequirementBooking1RequirementFilterRegion1

Alternatively create this cursor with ReadWrite clause and add this new item by inserting it.