>Hi.... (I love telecomm applications...)
>
>Since the rate is a function of the particular *customer* and not a function of the country or the call....you shouldn't have to get mixed up with the rate/country thing, except to simply find the country.
>
>Example:
>
>I'm Joe Blow from Columbia. I've been assigned rate #3. For every country, that I've made a call from, I have to pay for the #3 rate. So, if you were going through my calling records you would do something like:
>
>1. Find Joe Blow's rate for Joe Blow, or assign the rate of #3.
>
>2. For every calling record:
> a. find the country
> b. find the country's #3 rate
> c. multiply the rate x the # of seconds of the call
>
>Or am I missing something here?
>
>--- Larry


thank you..
if that was the case...
per say jowshmoe has asigned rate3
in the table of rates fiedname rate3 has many countryes records underneath...
like

record# code country rate1 rate 2 rate3
1 011578 Colombia .23 .28 .32
2 011589 Paraguay .38 .39 .11


if joe made calls to colombia they are going to be at .32 cents cuse i asigned joe rate3

and the same for calls to paraguay..rate 3 at 11cents
but to jenny i asigned rate1
calls to colobia are going to be rated at .23 cents

and so on....

please bare with me...i'm 2 days trying to do this whithout any help whatsoever..
thank you