I have just switched from another database to Filemaker Pro Advanced, because my old database does not have a Mac OSX version. I have searched for an answer to my question in the help areas, but cannot seem to find the right place. So, please forgive this basic question, if it is addressed elsewhere.
My question is this...I have several fields in my table that are always a currency field. The "type" selection only has a "number" type, and not a currency type. The problem this presents is that I can create a layout, and define those fields as currency and set the parameters. However, it only defines the field as currency on that single view of the report. Switching to browse, makes the field a standard unformatted number again. Creating another layout, means that I have to reformat those fields again.
Is there anyway to make a field to be globally formatted as currency? I would think there would be a way, so that the developer is not constantly repeating the same step.
Thank you for any assistance you may be able to provide.