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