fill 2nd combobox by choice 1st combobox

eddy147
Member Posts: 4
Hello,
I dont know how to do this:
On my form I have 2 comboboxes, first one with Employees, 2nd with Projects.
On the first, I select an EmployeeId. After selecting an EmployeeId, I want to see only the projects where this employee worked on.
How can I accomplish something like this in Ax 4.0?
I dont know how to do this:
On my form I have 2 comboboxes, first one with Employees, 2nd with Projects.
On the first, I select an EmployeeId. After selecting an EmployeeId, I want to see only the projects where this employee worked on.
How can I accomplish something like this in Ax 4.0?
0
Comments
-
This is really easy, you just add 2 StringEdit boxes to your form, and you have to
select the correct EDT for each control. For the employee box it should be ProjResponsible
and for the Project box it should be ProjId. On the Employee properties you need to enable
the 'Auto declaration' option.
And you need to overide the lookup method for the project box.
It should be something like thispublic void lookup() { TableId tableId = tableNum(ProjTable); Query query = new Query(); QueryBuildDataSource sbds; SysTableLookup sysTableLookup = sysTableLookup::newParameters(tableId, this); ; sbds = query.addDataSource(tableId); sbds.addRange(fieldNum(ProjTable, Responsible)).value(Empl.text()); // given that your employee box is named 'Empl' and the field you filter on is 'Responsible' sysTableLookup.parmQuery(query); sysTableLookup.addLookupfield(fieldNum(ProjTable, ProjId)); sysTableLookup.addLookupfield(fieldNum(ProjTable, Name)); sysTableLookup.performFormLookup(); }
0 -
This was just what I needed . Thanks !0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions