Hello, I'm trying to build my first database.

It's a database that I want to use to compare different fishing boats.

I would like to put different form field, like:

boatyard name

type of boat

lenght

weight

....

price

I have a problem with this field because I have prices in $ and €, how can I put the numeric value and than select the currency?

I would also like to build an automatic converter $-€. I tought about creating a new form with a numeric value for the change and than use a formula for the change calculation. Do you know if I can get an automatic update for change value?