AnsweredAssumed Answered

Modifiable Number field with auto entry from default settings table

Question asked by JerryAPowers on Aug 6, 2012
Latest reply on Aug 6, 2012 by philmodjunk

Title

Modifiable Number field with auto entry from default settings table

Post

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.

Thank you!

Outcomes