Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to emulate a dblookup

Posted on 2004-09-02
2
Medium Priority
?
343 Views
Last Modified: 2013-12-18
HI Guys

I have made a change and am nolonger using UNID for PArent Child relationship

I am using field value(Numbers)

I have a script
Set prdoc = currentdb.GetDocumentByUNID(xxpr_link1) I need to now get the parent doc based on its prnumber
which is in the xxpr_link1

Set podoc = uidoc.Document
      Dim xxoldTotal1 As Double                        ' This PO when it was opened.
      Dim xxpr_link1 As String      ' Link to PR      from this PO.
      Dim prview As notesView
      Set prview = db.getView("VPRNUM")
      uidoc.Refresh
      
      xxoldTotal1 = podoc.oldTotal1(0)            ' Initial value of this PO saved in PostOpen
      xxpr_link1 = podoc.pr_link1(0)
      
      Set prdoc = currentdb.GetDocumentByUNID(xxpr_link1)
      
      
0
Comment
Question by:imjamesw
2 Comments
 
LVL 13

Accepted Solution

by:
CRAK earned 2000 total points
ID: 11968202
You haven't given us your true question or problem.

Just two lines that provide an indication:
   "I have made a change and am nolonger using UNID for PArent Child relationship"
and
   "Set prdoc = currentdb.GetDocumentByUNID(xxpr_link1)"

If xxpr_link1 does not represent a doc id, we're talking about a lookup by KEY.
Perhaps this one might help you out:

Set prdoc = <ViewInstance>.GetDocumentByKey(xxpr_link1)

Of course you neet to define <ViewInstance> first, like:

myView = currentDb.GetView("<name>").
Make sure to sort by key, just as you would for @DbLookup.
0
 

Author Comment

by:imjamesw
ID: 11968358
I was playing around with by key however I was using the wrong indicator

Not the the view name

Duuuhh
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month12 days, 11 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question