I am trying to fill up a field according to the data of the another field.
If the value is not available in the list, It should allow to add with the auto insert to the lookup table also.
field1 -> (text field) use lookup table with Force Selection
In the lookup table the available data is
John
Bush
Jenny
Now when I type john or bush or jenny the list with the name is shown and I can select it from the list.
But Here if I type a new Name "James" I can not add it as it is not in the lookup
Here in my case, I want to allow the new value to be enter which is not available in the lookup table.