• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

How to emulate a dblookup

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
imjamesw
Asked:
imjamesw
1 Solution
 
CRAKCommented:
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
 
imjameswAuthor Commented:
I was playing around with by key however I was using the wrong indicator

Not the the view name

Duuuhh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now