14 Replies Latest reply on Feb 9, 2016 1:48 PM by nicolai

    Calculations in Views (SQL Server)




      I'm using File Maker 14 Pro with SQL Server (back end).


      I have a view that display data from one table, additional I have a function that display a result of a calculation (that comes from multiple tables).


      When I use the field on the form it prevents me from savings changes as it this that my calculation field cannot be updated (which is correct).


      Is there a way to have my calculations in the same view and "disable" update. This is a read only field.


      (My workaround was to split the view and put into a separate view with one to one relationship but search performance on the calculation is poor, and it means I have to develop two views per form table).


      Many thanks in advance