>Dovi... I think that is correct. The way that I think you've got this set up is that there are three tables: (.DBF files).
>
>1. the Customer file. This includes their name/address, etc. and their RATE.
>
>2. the Country file. This includes the country name, the dialing prefix
>
>011 US
>043 Austria
>049 Germany
>
>
>3. The calling records. These should include:
>
> a,) the dialed number from which you can find the country code<br>
> b,) something which identifies the customer<br>
> c,) the length of the call in seconds or minutes.<br>
>
>
>One problem I can see with this, is that it doesn't take into account differing rates at different times of the day. For example we might have Day rates of 40 cents per minute for in-state log distance calls, and Evening rates of 10 cents and Night rates of 2.5 cents. But, this should be a start.
>
>--- Larry
well thank you
its calculated throug a function by doing the fiference of starting time of the call minus ending time of the call converted to secons and as a result i get minutes and 100.....like 33minutes and 07...so i can multipley by numbers..
my view does have starttime, endtime,and customerid.....
now my rate table does not have customer id...the way i can relate itis
by determining the first digits of the call....like 011578935418 number dialed and the first digits is 011575..i can relate my view that has the callnumber to the rate tabel...but how do i do that...in relation to the rate that i chose for the customer...