Skip navigation


Top & Trending
Hi, I am new to filemaker. I have read few chapters of Database Design for Mere Mortals. The author told me not to use calculation field in a table. I guess what he means we could calculate the value in VIEWS or write query to display the result so it is not a must to include a formula in a field.   When we apply to filemaker, should we

This is driving me crazy. Using the field [CalcWrittenNumberA] for numerical input, everything is flawless in calculating the written number EXCEPT when the number has 00. (i.e. 100.00, 1,000.00, 12,000.00, 123, 000.00, ect). [and] shoule be inserted (which it is) except when there are no [hundreads].   I know where the problem is but just