Ha bejabers Mark - what are ya thinking? <g> Of course the accent does not come over in html but I still fondly remember it (the accent) and my bike trip with school-pals from across the channel to Dublin in the emerald isle many years ago.

Your select script should be along the following lines, I'm thinking.

select table1.* ;
from table1 ;
where table1.field1 in (Select table2.field1 FROM table2 WHERE WhateverFilter) ;
into cursor2

Obviously the data type and construct in table1.field1 must be the same as that in table2.field1 but the field names themselves do not need to be the same.

Hope that works for you. /spb