Hello everyone.
I'm having trouble getting a Forms lookup rule working correctly.
For some reason, if I create a rule that uses a string value, it doesn't work. If I use the number values, it does work. I would love to see the query statements that are run on the form to help troubleshoot, but I can't find them easily.
Here is what I have. A simple packing list upload form that should look up the PO details and fill in a table.
The Rule is that when a PO number matches a value from the table, fill in the item descriptions in the table.
It will not work and I'm loading the PO number values from the same table into the PO number field.
If I set up 2 number fields, 1 is the location(Division) and the other is the PO number, then the lookup works.
Why would the lookup fail for one of the values but not the other? Any ideas on how to track down the problem?
Discussion
Discussion
Forms lookup help
Conversion of a numeric to a string, or vice-versa, can sometimes be quite specific. Can you show the lookup rule, and the table columns (with data type)?
Sure thing.
Here is the one that isn't working.
Here is the data.
Here is a description of the data.
Here is the lookup rule that does work.
It doesn't make sense to me that I can't use the full PO Number.
Yeah it looks OK, except for "Full PO Number" not being a dropdown. Are you certain that Description1 is working properly? Try swapping the retrievals between Description1 and Description2 to make sure the result fields are configured properly.
Wait, you are selecting or typing the value for "Full PO Number", right? If the value doesn't change then the lookup won't be triggered.
I think I might have it.
I was able to get it working once I used a table that is much smaller.
I was worried that it was a timeout issue. I think that was the problem.
Message: ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0666 - SQL query exceeds specified limit or threshold.
I found the error.