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