is there anyway that i could send you the rates data base to see if you could posible help me with it.....
>Dovi ---
>
>Sorry for the delay in response...err...can you send me the tables or at least a sample of them to my default email address? Maybe if I saw them I could give you more concrete advice.
>
>
>
>>>What is the key between rate_code and customer? Is the rate code stored in the customer table?
>>>
>>>>>Hi Dovi ---
>>>>>
>>>>>OK, I think I see. So a customer has a rate, from 1 to 20. I assume this is stored in your customer table. Do you want to store the applicable rates from the rate table to the customer table? Of is this a look-up as needed?
>>>>>
>>>>>>code country rate1 rate2 rate3 rate20
>>>>>>011575 Colombia .23 .25 .34
>>>>>>011875 El Salvador .66 .43 .50
>>>>>>
>>>>
>>>>
>>>>*****************************
>>>>its like this..i am working with 3 tables and one view of calls
>>>>table1 is customers...with custid
>>>>table2 is rate_code...smal table with one field named code.(purpose so i can use it in a combobox to preset the rate on the customer, y could have used it with value too)
>>>>table three is my rates table ( i showed you how i have it setup)
>>>>
>>>>now my view has custid and the number dialed which thos are the items i can work with to create some kind of relation to the rate per call
>>*******************************************************************88
>>
>>would you help me out with the puzzle.....please...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only