I am in need of some guidance in terms of view creation. I have two forms from which I am trying to get data from in one view. My select statement is:
Select Form=“Form1”:“Form2”
I am able to get most of the information from Form1, but I need to get some of the information on Form2. Essentially, I need to use some of the information on form1 as a key to be able to display data in one column and then use that data to be able to display data in another column. The data in the second column would be keyed off the first one.
Unfortunately, @DBLookup can’t be used within a view column which is almost what I need to do. Any other suggestions would be appreciated.
If you use NSFDB2, you can create DAVs to publish the information to a DB2 table, and a Query view to do the join.
Otherwise, you can only display information in one view row from a single document. Of course, you could do something to arrange for the document to contain the information you need.