A currency problem!

O

ollygregory

Right...

I am working on a database that I built myself a couple of years ago
for a french property company in france. Within the database, there is
a form called 'Price and Fees.' This form works out the final price a
property will be and then converts it from French Francs into euros.

The way it works, is that a property's price is made up of individual
factors. The prices the property will actually sell for, the fee from
the agency, the fee from the estate agent etc. All these are entered
into the form manually in FF and then an expression calculates a final
price and turns it into euros.

This all works perfectly fine, but the company now wants to enter all
the prices in euros, have the total worked out in euros and then have
it transferred into FF for reference.

But what is my best bet???

I can easily create a form to do this, but theres about 300 records in
which the prices are already entered in FF and then wont work with a
form that expects prices to be entered in euros. I dont really want to
end up with 2 forms as I'd never know which records were afiliated with
which. Should I try and convert all the other prices so that they work
with the new system... or.... something else?!

I'm a bit stumped on what the best way to deal with this is, and hoped
someone would be able to point me in a useful direction!! :)

Thanking you in advance
 
B

Brendan Reynolds

I would either convert the existing data to Euro, so that all data can be
processed in the same way, or add a field to the table to indicate which
currency was used. Your calculations can then use that field to determine
whether the data needs to be converted or not.
 
O

ollygregory

Right... based on what you suggested, I decided that rather than mess
about trying to convert ALL of the old data into euros, I instead
adopted an option which allowed the user to select whether the inputted
data was in FFR or euros and then had the calculations worked out based
on the value in this field.

Nice and simple, and it worked :)

Thanks very much for your help!
 
Top