SELECT customer.CustID, rate.Rate, call.CallNumber < other fields here > ; WHERE customer.CustID = call.CustID ; AND customer.RateCode = rate.RateCode ; INTO cursor CallTempYou can make a parameterized view of it so you can change the Customer ID (or equivalent field) and refresh the view.
>code, country, rate 1, rate 2, rate 3, rate n >--------------------------------------------------- >011575 Colombia .23 .25 .23 .21 >011957 Braxil .33 .32 .15 .40 >011875 Barbados .10 .12 .18 .13 >if i set the rate on customer john doe to rate2 i need to determine the folloowing rates for these calls according to the table of rates
>date time1 time2 number dialed >050199 101000 101200 01157578342121 >050299 101000 112000 01187578342121 >050399 121000 151200 01157578342121 >050499 091000 101250 011957578342121 >050599 100900 101220 01157578342121>the question is what is the best way of doing this..can anybody help me...