>>**************************************************************************************************************
>>THANK YOU FOR HELPING ME..JUST A FEW MORE QUESTIONS
>>
>>WHAT IS Pv1-rate?
>>WHAT is m.code..?
>>
>>my call log table name is view1 and the field i need is dialednr
>>the rate table's name is rates and the field that has the first 6 digits of the call named is code
>>now the part of the customer where i have stored the rate names to pull them down and asign the to my customer,,,table name rate_code and the field name is code
>>
>>CREATE VIEW pv1_rate AS;
>> SELECT * ;
>> FROM rate ;
>> WHERE code = ?m.code
>>
>>m.code = SUBS(callId,1,6)
>>USE pv1_rate
>>
>>please help me i need it.......pleaseee..
>
>
>pv1_rate is defined in the Create View... p=parameterized, v=view 1=1st one.
>
>m.code is a substr of your code that depicts the first 6 characters.
>
>When you want to get another value, just change m.code and...
>Requery('pv1_rate')
>
>Wayne


IM SORRY WAYNE....THIS IS MY FIRST TIME USING VIEW....HOW DO I DOIT
WITH THE MENU CREATE A NEW LOCAL VIEW.....WHICH TABLES I NEED IN THEM AND WHAT KIND OF JOITS I NEED IF I CAN DOIT LIKE THAT, OR
CAN YOU EXPLAIN TO ME ALITLE BIT MORE ABOUT VP1...?

PLEASE HELP ME ...