General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
can anybody please help me
i have customer table with a custid table named reseller
the customer pageframes has a grid of a view where all the calls come in
the view name is view1 with customer id
on the second page of my customer i the enduser can preset a rate for those calls..the way i did it is created a litle table of one field name code..table name is rate_code...i the enduser chose through a combobox that specific rate ..persay rate 3..
this is my table of rates
code country rate1 rate2 rate3 rateN
011578 Colombia .23 .21 .28 .32
011789 Peru .31 .33 .30 .38
now the questions are:
according to the rate that i preset for this customer per say Rate 3
at what rate is he talking to Colombia or code 011575..
and custome john doe2 made calls also to 011575832566 but his rate was rate 4
what i need to use is tell the customer to use the column or field of the rate to match it with the first 6 digits of the number dialed...
PLEASE SOMEONE HELP ME..I WAS TRYING WITH A NEW LOCAL VIEW BUT I DONT KNOW WHAT TABLES TO USE OR WHAT TO JOINT WITH WHAT
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