You would use UNION
>
>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
--sb--