i have customer table with a custid table name reseller
the customer pageframes has a grid of a view where all the calls come in the view name is view1 with customer id
on the second page of my customer i the enduser can preset a rate for those calls..the way i did it is created a litle table of one field name code..table name is rate_code...i the enduser chose through a combobox that specific rate ..persay rate 3..

i created a table of the rates named rates with the following fields
code country rate1 rate2 rate3 rateN
011578 Colombia .23 .21 .28 .32
011789 Peru .31 .33 .30 .38

now the questions are:
according to the rate that i preset for this customer per say Rate 3
at what rate is he talking to Colombia or code 011575..

OR HOW CAN I WRITE A FUNCTIOND THAT SELECTS THE FIELD OF THE RATES TABLE THAT THE ENDUSER SPECIFIED AS A RATE FOR THE CUSTOMER...