First, you must have a customer code that is in both your Calls table and your Customer table - this will link your calls to a specific customer. Then link customer to rate:

SELECT customer.CustID, rate.Rate, call.CallNumber  < other fields here > ;
   WHERE customer.CustID = call.CustID ;
   AND  customer.RateCode = rate.RateCode ;
   INTO cursor CallTemp

You can make a parameterized view of it so you can change the Customer ID (or equivalent field) and refresh the view.

HTH
Barbara

PS: Use the < pre > and < /pre > tags to show the layout on your code snippets.

>i have a question ...
>i have a client table, a rate table and a view1 of all the calls made
>the rate is preset on a pulldown menu... now..
>
>my rate table goes like this

>code,   country,   rate 1,  rate 2,  rate 3, rate n
>---------------------------------------------------
>011575  Colombia       .23     .25      .23     .21
>011957  Braxil         .33     .32      .15     .40
>011875  Barbados       .10     .12      .18     .13
>

if i set the rate on customer john doe to rate2 i need to determine the folloowing rates for these calls according to the table of rates
>
>
>this is the view of calls for john doe

>date   time1  time2   number dialed
>050199 101000 101200  01157578342121
>050299 101000 112000  01187578342121
>050399 121000 151200  01157578342121
>050499 091000 101250  011957578342121
>050599 100900 101220  01157578342121

>the question is what is the best way of doing this..can anybody help me...