Summary

The behavior of lookup rules changed in Forms 9.1. By default, lookup rules will populate the matched field with possible values from the data source. In some cases, this behavior is not desirable.

History

In Forms 9.0, drop-down fields auto-suggested but single-line fields did not. In Forms 9.1, both drop-down and single-line fields auto-suggested. In Forms 9.1.1, you have the option to turn off the auto-suggest behavior by adding the aforementioned setting to the database.

Solution

On the product-level, you can disable the auto-suggest feature of Forms 9.1 lookup rules.

To disable the auto-suggest lookup rule behavior

1. Using SQL Server Management Studio, open the database specified on the Database tab of the Forms Configuration page.
2. Under Tables, right-click dbo.cf_options and select Edit Top 200 Rows.
3. Add a new row. In the optionname column, enter DisableAutoPopulateIn91. In the optionvalue column, enter true.
4. Save your changes and exit SQL Server Management Studio.
5. Restart IIS on the Forms Server machine. Click Start, All Programs, Accessories, and then click Run. In the Run window, type IISReset and click OK.