I have a FORM called People, and consider it to have only two fields :
NAME
COMPANY
Second form is 'CATEGORY' with two fields
COMPANY
CATEGORY NAME
I have another FORM called 'Request', with the following Fields
NAME - Lookup from form 'People'
COMPANY - Single Line
CATEGORY - Lookup from 'CATEGORY' using Criteria Category.Company=input.Company
Request Detail - Multi Line
I have some deluge script on 'User Input' for the FORM 'Request' whereby, I get the 'PEOPLE' record corresponding to the name entered and from this I can derive the persons 'COMPANY', I then set input.Company = people(name=input.name).Company
Now this so far works fine....
However, the set-criteria for the lookup of Category doesn't work and my lookup drop-down is not populated.
but if I manually enter the Company Name, I can see the little spinning circle doing come calculation and the lookup dropdown for Category is populated.
It appears that when using a 'Set Criteria' for a lookup, that relates to an input field, when the input field is populated though the GUI, the criteria is applied, yet if the criteria field is populated via deluge script, the processing to filter the lookup does not take place.
Any Guidance much appreciated !
Neil