Return Item for LOV in Forms4

From: Michael Stowe <Michael.Stowe_at_f573.n115.z1.fidonet.org>
Date: Fri, 11 Mar 94 18:21:01 -0600
Message-ID: <24029052_at_f573.n115.z1.fidonet.org>


Suggestion 1) Do NOT use a global. It is inappropriate in the given context.  Not only is a global limited to the character type, and should be destroyed after using, but it also does not allow the attachment of triggers which you clearly need.
2) When-new-item-instance is probably not the trigger you are looking for. If the user is navigating to the field before the LOV is raised, the trigger when-new-item-instance trigger is firing -before- the LOV is called. If the LOV is called in another way, the when-new-item-instance trigger may never fire. Clearly, you want a trigger that fires -after- the LOV is called, and when the item is changed: when-validate-item. To summarize, what you will want to do is place the name of the null canvas item you create in the return item setting of the LOV properties. Then attach a when-validate-item to your null canvas item which copies its value to the other fields you wish to fill with the values from the LOV. What will happen is when the LOV is selected, it will place a value in the null canvas item, which will fire the when-validate-item trigger, which will load the value from the null canvas item into other items.

Note that if you wish to coordinate the values of the text items to each other independently of the LOV, a different approach is warranted.

Michael Stowe
Director of Technical Services
Constellation Engineering
stowe_at_aol.com Received on Sat Mar 12 1994 - 01:21:01 CET

Original text of this message