hello, I have a field in my database, the field is set as currency. Now we are having a problem when insert the prices:
1. we insert the price with the dot, as the image shows
2. when we click outside the field we get the number in thousands (not as we introduce it), as the image shows.
3. then we go to the field and change the dot for a comma, as the image shows.
4. then we click outside the field and we get the right value, ( filemaker replace the comma for a dot), as the image shows
please let me know how to fix this? right now we have to introduce the prices with commas to get the right value.
thank you very much