Hi there



I've got the following query (running off Access97 in ASP):



SHAPE {SELECT * FROM tblOpinions} 

APPEND ({SELECT * FROM tblLeadManagers WHERE LeadManager = 'me'} 

AS LeadManager 

RELATE OpinionID to fkOpinionID) 



As you can see i've substituted what will be a parameter with a 

static 'me'. The problem is I want the query to return all the Parent 

records which have child records WHERE LeadManager = 'me' and have all the 

LeadManagers returned, not just those with 'me' (strange, I know, as i'm 

searching on it).



As it is, it returns all the Parent records, regardless, and simply omits 

the child record which isn't 'me'.



Can anyone tell me what the correct query is?



Cheers,



Colin