Duplicate PLD

[Former Member]

Good Day Mentors,

Currently working on forms.

I made a duplicate copy of VPM10001 (Outgoing Payments).

Aside from the data from the said system template, I need to display the Credit(JDT1.Credit) and Debit(JDT1.Debit) from the Journal Entry - Rows(JDT1).

Now if i add a database field and go to Properties - Content Tab, and use the drop down menu to pick the database table JDT1, the table is not listed there. I just discovered in this forum about using ALT+Mouse to show all tables in the drop down list. I used it, and was able to get the Credit(JDT1.Credit) and Debit(JDT1.Debit) from the Journal Entry - Rows(JDT1). The problem I am experiencing now is I am not getting the data for those fields.

Is there a something else that I left out?

Is the PLD engine able to connect/link/query those fields i need automatically?

Or do I also need to set something all the time when I use ALT+Mouse to get certain fields that are not in the original template?

Thanks & Regards,

Sean

SBO 2007A PL42

[Former Member · Accepted solution]

The problem for PLD link is: it only suppors primary key link

[Former Member]

ALT+Mouse is not supported tools that open to some special needs only. You have to manually link all tables if you use it. Many links are difficult or not possible. PLD is not the tool to get other data from other table. Only UDF in the current table will work easily.

Thanks,

Gordon

[Former Member]

Thanks Gordon for the quick reply.

In my case, I assume I will be linking it this way in terms of Query Generator terms

OVPM T0  INNER JOIN OJDT T1 ON T0.TransId = T1.TransId INNER JOIN JDT1 T2 ON T1.TransId = T2.TransId

Which I think isn't that long. If so, how do link those fields?

Thanks,

Sean