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

    Calculations in Views (SQL Server)

    katieandemil

      Hi,

       

      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

      Emil