>Dovi,
>The problem is that you have a column for each rate. Can you redesign your rate table so that each record has only one rate?

code     Country     Rate   Rate#
>011578   Colombia    .23    1
>011578   Colombia    .21    2
>...
>011789   Peru        .31    1
>...

Then you would join the country/code AND the rate# value to the customer with HIS rate#. I hope this is clear.
>
>If you can't redesign the Rates Table, you may need to pick then information out by searching each column. Very time consuming, and the code has to be rewritten each time you have a new rate #.
>
>HTH
>Barbara
>
>>can anybody please help me
>>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..
>>How do i do this.......
>>what tables need to be related with what..or do i create another cusor view, with waht kind of joit and what neds to be init..
>>
>>please help me i need it..thank you


***************************8
thank you so much...do i would doit like this??

code ratename country price
011575 cw_1 Colombia .32
011572 cw_1 Colombia .32
011575 Cw_1 Colombia .32
011453 CW_1 Peru .67
011456 cw_1 Peru .67

and the same thing for ratename CW_2 ut to 20..?