Skip to main content
Solved

Linking ARInvoice table to CRActivity table


Forum|alt.badge.img

I am trying to build a GI with the invoice info and the activities that belong to it.  I was trying to link table ARInvoice with CRActivity.  Has anyone linked these two table up before or know if i am targeting the wrong activity table ?  Thank you .

Best answer by lauraj46

Hi @alicia23 ,

You should be able to join on ARInvoice.noteID = CRActivity.refNoteID , like so:

Laura

View original

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 512 replies
  • Answer
  • June 10, 2021

Hi @alicia23 ,

You should be able to join on ARInvoice.noteID = CRActivity.refNoteID , like so:

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 41 replies
  • June 10, 2021

THANKS Laura!!! that worked …. i could have sworn I tried that before but i think i had the parent and child fields backwards 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings