C
chriske911
what is the best way to engineer an interface for exchange rates?
anyone who did this already?
I was thinking of using a tab page control per currency and linked to a
parent form holding the date(s)
this makes sense since there are but 4 currencies but what if there are
more?
I know of these lists as they tend to use on exchange websites but
because of the custom relationship in my database I don't see an easy
way to implement this
right now I have a table holding exchange rates from any currency to
Euro's and this for every date necessary
this makes it possible to calculate from any currency to any other
currency for every order
this design uses 3 tables, one for the orders, one for the XC rates and
one table in the middle because of the many to many relationship
between orders and XC rates
the orders table is linked to the inbetween table using two fields
(date and currency), the inbetween table then adds an auto ID field
which is then used in relation to the XC table
I hope this makes sense to you guys and dolls
thnx
anyone who did this already?
I was thinking of using a tab page control per currency and linked to a
parent form holding the date(s)
this makes sense since there are but 4 currencies but what if there are
more?
I know of these lists as they tend to use on exchange websites but
because of the custom relationship in my database I don't see an easy
way to implement this
right now I have a table holding exchange rates from any currency to
Euro's and this for every date necessary
this makes it possible to calculate from any currency to any other
currency for every order
this design uses 3 tables, one for the orders, one for the XC rates and
one table in the middle because of the many to many relationship
between orders and XC rates
the orders table is linked to the inbetween table using two fields
(date and currency), the inbetween table then adds an auto ID field
which is then used in relation to the XC table
I hope this makes sense to you guys and dolls
thnx