This should be the simplest thing in Notes, but it isn't or I am seriously missing something.
I have a "locform1" form that has 2 fields on it... location1 and person1. There is a view that selects those location documents called locview1. Essentially this serves as a lookup mechanism for combo and dialog lists in other forms and allows the users to maintain their lists dynamically.
I have a form called msdsform1. There are 2 fields on the form, field1 and field2. When someone picks/sets a value in field1 with the contents of location1, then field2 should get populated with the contents of person1.
What I have done in the past is to create a hidden field on the form that is calculated when composed. Then use an action hotspot or button to pop up an @picklist using the "view" parameter and then surrounding that with an @setfield and setting my hidden field to the docid. Then call an agent in lotusscript that retrieves the contents of the hidden field and does a get doc by unique id using that as the key and then followed by a bunch of setfields to update values on the form.
Although this works, I think it is crazy.
My next thing to try is to create a locform1 with a blank location1 field. Then set the default value of field2 to an @dblookup statement and change field 1 to refresh keywords on change. I doubt the @dblookup will reexecute and update with the correct value... but I will try it.
There has to a better way of doing this that I'm just plain missing.