AnsweredAssumed Answered

Change Value List When "Other" Value Entered

Question asked by Sealander on Apr 21, 2012
Latest reply on Apr 21, 2012 by bumper


Change Value List When "Other" Value Entered


Let's say I have a checkbox form associated with a field "Fruit" whose value list is populated from the field of another table. In the checkbox properties I have "Allow Entry of Other Values" selected so there is always an "Other" checkbox at the bottom. If someone enters a new value, say "Apple", manually I want that value to be a new record in the "value list" field from the other table so it will be a future option for others. I'd be really grateful if anyone has any ideas. Thanks.