Hi all,
I have tables of calling rates. I have 5 tables as follows:
Table Name
Field Name (Data Type)
Description
_tblAccount
AccountID (AutoNumber), AccountType, AccountDescription
It's an account type such as pre paid or post paid
_tblEmployees
EmployeeID (AutoNumber), FirstName, LastName, Mobile1, Mobile2,
Mobile3, WorkPhone1, WorkPhone2
_tblProvider
ProviderID (AutoNumber), AccountID (Number), CompanyName, ....
list of all the providers. I have 7 providers (7 rows) so far.
_tblProviderRates
ProviderRatesID (AutoNumber), ProviderID (Number), CountryCode,
Country, Rates
I have different rates from 7 different providers. All these dates
depend on Country Codes. One country code can have more than 1 rates.
_tblRe****t
Re****tID (AutoNumber), EmployeeID (Number), ProviderID (Number),
ProviderRatesID (Number), Re****tDate (Text), CountryCode (Number),
CallingSec (Number), CallingMin (Number), CallingHour (Number),
NewRate (Currency), NewRateDate (Date/Time)
This is a detail table. I am im****ting from excel sheet EmployeeID,
ProviderID, Re****tDate, CountryCode, and CallingSec in this table.
What I want is ProviderRatesID must show me the provider name so that
I can include rates in this detail table from tblProviderRates.
For example, I have customers who have used 3 different providers with
3 different rates. I want to show them in my tblRe****t table.
Now, they supposed to match with calling codes as for example again;
provider A rates for CountryCode 1 is 0.009 and provider B rates for
CountryCode 1 is 0.010. I want to see these rates in my tblRe****t.
Once I have this I can do some artihmetic.
Thanks.
|
