Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
right syntax for writing a query to a form having 3 ds.
ebrahimma
Member Posts: 2
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
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
0
Comments
add another table - VendBankAccount - join source - VendTable
set properties - allow create and allow delete to "NO".