>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....


*************************************
hi im sorry to bother you, i really need your help IF POSIBLE..

now...
my customer table has an customer id
we preset the one 800 numbers the customer screen and they are stored in another table called numbers that does have customer id (with replace)
then both can be related to each other..now my call log table does not have a customer id but can be related to numbers in with another field...so i made the retationship with a view of customers and call log..

the enduser can set the rate to be used for this customer.example rate2

my customer's tables name
resellers.resellerid

my call log tables name
datafile

my number to preset the one 800 numbers
numbers

where i set the rate for the customer is
rate_code only contains the code to be used in a combo to select the rate for customer

my rates table's name is
rates and it looks like this

code county rate1 rate2 rate3
011575 Argentina .25 .29 .28 ans so on..

please help me out i need it..Thanks