right syntax for writing a query to a form having 3 ds.

ebrahimma

hi guys.

i'm new in x++ development . i hope u can help me

in the "Global Address Book " i want to add a new tab which is actualy the "VendbankAccount" form.

the purpose is when user chose one vendor and move to the bank account tab, it will show only that vendors' bank account details.

the problem is that the "DirParty Table" and the "VendBankAccounts" Table have no common field so i cant use the direct join property, however using the Vend Table can be can help writing a right query to do the job since it has :

1. vend account field which is common with the vendbank account .

2. vend partyId field which is common with the DirParty Table.

I've tried to write a code using the addDatasource and addRange methods with no success.

Can you tell me what's the right syntax?

is this should be writen in the init() method of DirPartyTable datasource or anywhere else?

Tank you

kranthi

Add a new data source - VendTable - join source - DirPartyTable
add another table - VendBankAccount - join source - VendTable
set properties - allow create and allow delete to "NO".