It appears that you just want to change the currency symbol used on the dollar amounts on your layout.
I don't think that you want to recalculate currency values via an exchange rate if you change the currency selected in this field...
You can define a text field to format with this value list of currency symbols.
You can then remove the currency symbol from your data formatting on all currency fields and put this text field to the left of them. For a layout set up for printing the invoice, you can also use Merge text that includes both the currency symbol field and a currency amount field to show the symbol to the immediate left of the left most numeric digit.
thanks so much for your prompt reply. Yes, I only want to do the field on the invoice details layout. I am using FM 13 starter solution
" INVOICES" -
ok as per your directive -
i will create a TEXT FIELD with all the Currencies on the drop down to be selected. Question 1 - is there a currency list FM already has done- like in INSPECTOR box? - can i copy / relationship from there?
question 2 - I must admit I am not a computer person. know very little - can you suggest a person (consultant) that can work with me on this? - I also started a new database (INVENTORY) - for my products and need some tweeking on that database too! Running FM SERVER 13
THX SO MUCH. Have a nice day. JOE
You will have to create your own value list. No such value list is accessible for a field in the database.
I cannot recommend a consultant. But you can ask for one here in this forum or select the consultant option from the Support drop down at the top of this screen.