Jump to content

Currency field- can it be editable or dynamic?


llpeters
 Share

This topic is 2817 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi All!

I work in a database that has several currency fields all set that way in US dollars. Maybe 1 out of 10 times I need to create a record where the currency would need to be displayed in euros, pounds, etc. Is there a way to make the fields editable so that I can ovverride the $ symbol only when I need to? Its not worth making the fields general since the majority of the time the value is $. Its also too clumsy to make a drop down box next to each field where you can select the currency symbol because there are MANY fields on the layout that display currency and its already a tightly structured layout. Any other ideas? Thanks! 

Link to comment
Share on other sites

I take it these are not really currency fields. But they are, perhaps, price fields, that is, number fields, which may be entered in units associated with the currency. Do you ever need to aggregate these? For instance, generate totals? In which case you would NOT merely enter the currency symbol, but most likely require fields for net foreign price, currency type, exchange rate, and calculated USD. For instance. Just displaying the intended currency symbol within the field does not solve the whole problem.

Link to comment
Share on other sites

This topic is 2817 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.