Frederique
Registered User.
- Local time
- Today, 16:11
- Joined
- Sep 5, 2016
- Messages
- 17
Evening chaps,
I've been learning about databases the pas few months and i've come a long way since the start. However i hit a wall as how to tackle the following problem. I read a lot on this forum but theres no clearsolution to my situation.
We have a company in the UK that produces stuff so the product cost is in £. We also sell in europe so i need a value in € for cost and selling price on time of the order input. When setting up my form+subform for order input i realised i offended the rules off normalisation. I thought i needed to input the currency and conversion on order level + the same on the orderlines level for safekeeping if theres an update/change.
This made me realise that this probably isn't the way forward since if i have to store the same thing multiple times.
So in short.
Where do i put the currencies/conversion rates? I have a seperate currencytable for lookup reasons. At first i figured i could put conversionrates in that table but if they change my orders change as well.
I've been trying so far:
*using nested iif functions to recalculate whatever currency is specified to €. But when going further adding discounts and tax and freight and so on it looks cumbersome so clearly i haven't the ideal solution.
*also used the double, standard format without any currency symbol hence the reason why i've used a lookuptable to specify the currency per order and product. This way i can add it later on in reports based on the currency selected.
Customers,suppliers,projects,shipping,products and so on all work together like a charm but i can't seem to overcome this important obstacle. If i can get a push in the right direction as where to store what, or how you pro's would tackle this, that would be helpfull. Thank you kindly in advance.
I've been learning about databases the pas few months and i've come a long way since the start. However i hit a wall as how to tackle the following problem. I read a lot on this forum but theres no clearsolution to my situation.
We have a company in the UK that produces stuff so the product cost is in £. We also sell in europe so i need a value in € for cost and selling price on time of the order input. When setting up my form+subform for order input i realised i offended the rules off normalisation. I thought i needed to input the currency and conversion on order level + the same on the orderlines level for safekeeping if theres an update/change.
This made me realise that this probably isn't the way forward since if i have to store the same thing multiple times.
So in short.
Where do i put the currencies/conversion rates? I have a seperate currencytable for lookup reasons. At first i figured i could put conversionrates in that table but if they change my orders change as well.
I've been trying so far:
*using nested iif functions to recalculate whatever currency is specified to €. But when going further adding discounts and tax and freight and so on it looks cumbersome so clearly i haven't the ideal solution.
*also used the double, standard format without any currency symbol hence the reason why i've used a lookuptable to specify the currency per order and product. This way i can add it later on in reports based on the currency selected.
Customers,suppliers,projects,shipping,products and so on all work together like a charm but i can't seem to overcome this important obstacle. If i can get a push in the right direction as where to store what, or how you pro's would tackle this, that would be helpfull. Thank you kindly in advance.