AnsweredAssumed Answered

Calculations in Views (SQL Server)

Question asked by katieandemil on Feb 7, 2016
Latest reply on Feb 9, 2016 by nicolai



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