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 .
Linking ARInvoice table to CRActivity table
Userlevel 7
+8
Hi
You should be able to join on ARInvoice.noteID = CRActivity.refNoteID , like so:
Laura
THANKS Laura!!! that worked …. i could have sworn I tried that before but i think i had the parent and child fields backwards
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.