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