>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement