Dynamic picklist updates on manual entry, but not on scripted entry to reference field.
Hello,
I have a form with 2 lookup-picklists ("A" and "B"). First the picklist A selects a record from a database. An OnAdd / Success script for this picklist uses the selected value to populate two fields (field1 and field2) with information extracted from the selected value.
The second lookup-picklist (picklist B) uses the values in the two fields to create a dynamic picklist to further select records from the same database based on criteria for the picklist that filters against fileds1 and 2.. The criteria was entered when creating the form.
My problem: The script properly inserts values into field1 and field2 I can see them show up on the form. However Picklist B does not populate. But when I manually enter the exact
same values into field1 and field2, the picklist B works as it should.
My criteria definition for the filter for picklistB seems to be fine (it works with the manually entered values), but somehow it is not recognizing the same field values when added to the referenced fields (field1 & 2) via the OnAdd script. I assume it should, but maybe this isn't a correct assumption.
By the way, I am using this form as a sub form. I created a subform version of the same scripts (with row.x instead of input.x) and I get the same behavior when used as a sub form and when entered directly as a normal form.
Any suggestions? Thanks.