Modifiable Number field with auto entry from default settings table
I'm thinking that there is probably a simple solution to this. I am trying to have a number field that can be modified that contains the value from a separate table. However, when I create the field with the auto entry the default settings entry from the other table will not appear. However, when I make it a calculation field that simply inserts the Default Settings value, I cannot modify the field.
I don't want to simply insert the field from the Default Settings table because this will modify the calculations for all of the other records.
I tried having the number field with an auto entry calculation that uses the GetAsNumber function, but it will not retrieve the Default Settings field content.