[AccessD] Currency display issue

I've got a form and a subform (LOL). Actually I don't, I just thought 
I'd say that.

I have a different problem, and suspect that our Euro members may have 
the solution I need.

There's a Currencies table, a Products table, and Sales and SalesDetails 
tables.

Suppose you live in New Orleans, but you want to buy a product whose 
price is expressed in Euros. Fine so far. Next sale, customer is in 
Quebec, product expressed in Yen.

I need the form to respond intelligently with its Currency columns. We 
have mandated that only one currency can exist per sale (and all its 
details), but said form must be able to switch from the $ sign to the 
Euro sign to the Yen sign etc., based on the value of the CurrencyID 
column.

I have no idea how to do this. At the moment every amount has a $ sign 
in front of it, even if the currency is Euros. Not only does it look 
stupid, it confuses the users.

Any suggestions?

TIA,
Arthur

>>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.6 - Release Date: 2/7/2005