Yes. Thats what I thought you were doing anyway was sending me some representative data. If you send it after 5PM, send it to
i486dx@prodigy.net which is my home email.
>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...
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05