I have a document number that is created programatically in this document and this number corresponds to another form in the database. My question, how can create a link to this number.
Form 1 ABC no. - 123 - I should be able to link to form 2 when I click on 123
Form 2 DEF no. - 456
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
FORM1 has a number created automatically when saved. Let's say 1234. Then, you click a button in FORM2 to create FORM2. Form2 also has its own number say 4567.
Now, when I open FORM1 again, it will have both numbers shown.
FORM1 1234
4567
this number should be able to open up each other or linked to each other. When I click on 4567 FORM2 should come up.
I do not completely understand the flow of actions...
1- You create a doc1 with Form1, and at saving time its ID number is generated.
2- Then you create a doc2 with Form2, and at saving time its ID number is generated.
3- You finally want doc1 to show a link to doc2 named doc2.ID( 0 ) and doc2 to show a (backward) link to doc1 named doc1.ID( 0 )
Here the problem is that when doc1 is created, it does not know anything about doc2 yet, so it's not possible to create a (forward) link at that time. Instead when doc2 is created, it already knows all about doc1, so you just need to execute the following code at the end of the querysave event script fo the Form2 form, after the generation of ID
Dim doc2 as NotesDocument
Set doc2 = Source.Document
Dim doc1 as NotesDocument
Set doc1 = session.CurrentDatabase.Ge
Dim link1 as New NotesRichTextItem( doc1, "Link" )
Call link1.AppendDocLink( doc2, "", doc2.ID( 0 ) )
Call doc1.Save( True, True )
Dim link2 as New NotesRichTextItem( doc2, "Link" )
Call link2.AppendDocLink( doc1, "", doc1.ID( 0 ) )
Then
1- put a Link richtext field in each form (Form1 and Form2) for showing the link
2- put a UNID1 field (Computed for display) in the Form2 form and use @InheritedDocumentUniqueID
3- check the flag in the Form2 form where says "On Create - Formulas inherit values from selected document".
4- Finally always create doc2 having selected doc1 before, either in a view or opened.
NOTE that if you want to use an different method for getting at doc1 from doc2, then you should change the line marked in the code snippet, and points 2 through 4 maybe discarded altogether
Business Accounts
Answer for Membership
by: HemanthaKumarPosted on 2004-10-11 at 11:32:36ID: 12279369
Create a view with first column the no field and second col evaluating to @DocumentUniqueID...
Do a dblookup to this view and extract the 2nd col using the no field as the key
eg;
@DBLookup( "Notes":"NOCache"; @DBname; "VIewToLook"; No_FIELD_Name; 2)
Place this formula in a computed field.. When you save and reopen this will become a link
~Hemanth