Hi. I am looking to add in the related Service Appointment Number to the Sales Orders>Invoices GI. Since the only place that number exists is in the FSARTran table, I added that in, but can’t get my relationships right. Here’s what I have now in the Relations tab. I found previous input on this forum ..
Getting this error every time:
Best answer by Laura02
Hello,
I think you want ARTran on the left and FSArtran on the Right, if using Left Join.
It may also work fine, to change the Join type on the last two tables (last line joining ARTran and FSARTran) to Right.
Please let us know how it works.
Laura
+19Hello,
I think you want ARTran on the left and FSArtran on the Right, if using Left Join.
It may also work fine, to change the Join type on the last two tables (last line joining ARTran and FSARTran) to Right.
Please let us know how it works.
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
