I'm a newbie to Domino and Lotus Designer, and am loving the seemingly inexhaustable flexibility and power that Domino has to offer. But I was wondering if someone could help me with what is probably a very simple question.
I have created two Notes databases on the same server. Addresses.nsf contains static customer contact information. Incident.nsf is a primary customer-facing database which is used to track daily contact events. From within Incident.nsf I want the user to be able to use a pull-down list to select a customer contained in the address.nsf database, and then once chosen, to have some additional fields from that same document to be carried over and populated in the incident form currently being edited.
To do this I have done the following: From within Incident.nsf I setup a listbox field which uses a @DBColumn lookup to provide the drop-down list of names which can be selected as valid name choices (@DBColunm("":"NoCache";"":Address.nsf";"ListAll";1). This functionality works exactly as I want. But the problem I have is in how do I also pass along other field values from this chosen external document back to the current incident form being created in the Incident.nsf database to populate other fields?
Example of information I would like to transfer back to the current form are things like street address, city, state, etc. which are directly related to the name which was chosen from the listbox names pulled by the @DBColumn formula. I would like the names field to be populated by the @DBColumn procedure (or any other method if there is a better way to do this), and then based upon whatever the choice is chosen from that list; the related field data information will be automatically populating the corresponding fields in my incident form.
Any info that someone could give me to point me in the right direction to accomplish this task would be very appreciated.