>>>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...
>>\
>>************************************************8
>>that would be really really appreciate it..i undrestoord what you mean..i

created a new database but i do not know how to copy and append the records into it...the orginal database and the new one are on the way
>
>
>
>what is your email adress



john what is your email adress..........? thank you much