I have a 2 forms which I want to open in internet browser. This is bascially for web. In first form, I have two fields like ID and on the second form there are fields like Name, Age. Now when I click on the button it runs the agent. Agent will fetch the data from oracle or notes view on the basis of ID field on the first form. Actually ID field value is passed to the agent through the query_string. This agent also open the second form after fetching the Name, Age values.
now I will not be able to pass the Name, Age values to the second form from the agent. I do not want to use @dblookup on the second field. What are the ways to do it?
Subject: RE: How to pass value from one form to other
But the thing is I do not want to pass it through the query string. As I had taken a example but in real I have 20 fields on the 2nd form. So it is not good to pass 20 values through query string. That is why I do not want to use @dblookup coz it is not good to use @dblookup on 20 fields. I think it slow donw the application.
You can get 20 fields’ worth of data in one @DbLookup – just convert all of the data to text and put it into a single view column with a recognizable separator between data chunks. You can do the lookup in a computed-for-display field, then use @Word against that field to break the data up. Keep in mind, though, that this will have the same problems as the LotusScript version did – the first document needs to saved with any new changes and must have time to be properly indexed into the view before it will be available to a lookup. Changing languages doesn’t eliminate the problem.