It might be a simple question...

[mfuenzalida]

Hi, I'm new to FileMaker and I've just created a database to keep track of my company's bank operations (loans and stuff).

The problem I have now is that we used at least 3 different curriencies due to our international market.

What I'm trying to do (and I hope some of you will help me accomplish) is the followin:

Whenever I open my "Banks" database I want Filemaker to ask me for the current currency conversion value for that day (I work mostly on chilean pesos, but I also use US dollars and euros), after that I want Filemaker to calculate the total balances of my debts in chilean pesos, according to the currency value I entered at the start.

I could do this entering the currency conversion value for each record, but we're talking about at least 50 diffent loans, so it would be much easier to enter that value just once a day.

Regards from Chile

Matias

[danjacoby]

Off the top of my head...

The currency conversion values should be global fields, one for each conversion (i.e. pesos/dollars, pesos/euros). Put them on a layout by themselves.

Have a script run on opening that goes to this layout and clears the global fields. Then enter the values. Finally, have a button on this layout that checks to make sure that all the values are entered, recalculates the various debts, and goes to whatever layout you wish.

That should do it.

[mfuenzalida]

Thanks a lot, I guess it was a simple question, but I'm just starting to read the manual...

[Vaughan]

A field in a "prefs" file might be better than global fields, especially if the system will ever be used multi-user.