>>
>>Brett,
>>Would you try this :
>>
>>SELECT P.Username, P.Phone, C.KidFirstName, C.KidLastName,
>>S.Status, Pr.Priority
>>FROM force Parent P ;
>>left join StatusLookup S on P.StatusKey = S.StatusKey ;
>>left join Child C on P.ItemKey = C.ItemKey ;
>>left join PriorityLookup Pr on C.PriorityKey = Pr.PriorityKey ;
>>WHERE P.Username = "SMITHBOB"
>>
>>Cetin
>
>What does the FORCE do? And why did you convert Parent to P, Child to C etc?
BTW I'm not sure if access driver supports 'force'
Cetin