General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
can anybody please help me
i have customer table with a custid table name 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..
i created a table of the rates named rates with the following fields
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..
How do i do this.......
what tables need to be related with what..or do i create another cusor view, with waht kind of joit and what neds to be init..
please help me i need it..thank you
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