www.hkvforums.com

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.

bui wrote:

field1 -> (text field) use lookup table with Force Selection

Then you should not enable Force Selection.