Then use the phone number where I used customer ID - what I meant was for you to use the field that is in both tables.

HTH
Barbara

>hi barbara, first i like to thank you..
>the problm that i have is that my calls table comes from a harros telephony system in raw data and it does not have any customer id...the way that i link them to the customer is by doing a view with an inner joint to preset phone numbers......joined with calls....