Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Best way to supply choices to a user for ease of data entry
headley27
Member Posts: 188
For ease of data entry I would like to allow a user to select values from 2 lists (somehow linked) and Navision would populate a separate table accordingly.
For Example:
Step 1) The current record tied to 'Form A' is found in 'Table A'.
Step 2) The user clicks a checkbox on 'Form A'.
Step 3) The user is automatically provided with 'List 1'.
Step 4) The user selects a value from 'List 1' preferably by double clicking.
Step 5) The user is automatically provided with 'List 2' and the values displayed are 'filtered' based on the selection from 'List 1'.
Step 6) The user selects a value from 'List 2' preferably by double clicking and both selected values are stored in 'Table A'.
Since the values from 'List 1' and 'List 2' must be related, they must reside in the same table or be somehow linked.
Additionally, the values in 'List 1' and 'List 2' are to be displayed distinctly although the values in the associated table(s) is(are) not.
If a single table is used ('Table B'), data would be stored as such:
Field 1 Field 2
Circle White
Circle Black
Square White
Square Black
Triangle Red
Triangle Black
When displayed to the user 'List 1' would show
Circle
Square
Triangle
If Circle is chosen, 'List 2' would display
White
Black
If Triangle is chosen, 'List 2' would display
Red
Black
Again, the selected values would then be stored in 'Table A'.
What is the best way to achieve something like this?
Any suggestions would be greatly appreciated.
Thank you very much.
For Example:
Step 1) The current record tied to 'Form A' is found in 'Table A'.
Step 2) The user clicks a checkbox on 'Form A'.
Step 3) The user is automatically provided with 'List 1'.
Step 4) The user selects a value from 'List 1' preferably by double clicking.
Step 5) The user is automatically provided with 'List 2' and the values displayed are 'filtered' based on the selection from 'List 1'.
Step 6) The user selects a value from 'List 2' preferably by double clicking and both selected values are stored in 'Table A'.
Since the values from 'List 1' and 'List 2' must be related, they must reside in the same table or be somehow linked.
Additionally, the values in 'List 1' and 'List 2' are to be displayed distinctly although the values in the associated table(s) is(are) not.
If a single table is used ('Table B'), data would be stored as such:
Field 1 Field 2
Circle White
Circle Black
Square White
Square Black
Triangle Red
Triangle Black
When displayed to the user 'List 1' would show
Circle
Square
Triangle
If Circle is chosen, 'List 2' would display
White
Black
If Triangle is chosen, 'List 2' would display
Red
Black
Again, the selected values would then be stored in 'Table A'.
What is the best way to achieve something like this?
Any suggestions would be greatly appreciated.
Thank you very much.
0
Comments
It is like this:
1st table - Shape
Circle
Square
Triangle
2nd table - Color
Red
Green
Black
Pink
3rd table - Shape Color (table relation of 1st field to table 1 and 2nd field to table 2)
Circle, Red
Circle, Black
Triangle, Red
Triangle, Green
In this case, you can create some table where you have two fields:
Shape field - table relation to the 1st table
Color field - table relation to 3rd table filtered for Shape field value
After that, you can select the values in standard way, shape at first and correct color into second field. Or you can change the OnLookup of the first field and let user to select the color in one step...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Item Unit of Measure
Stockkeeping Unit (an example of a three-way link)
Item Translations
Vendor Bank Account
Item Vendor
Ship-to Address
and many more.
RIS Plus, LLC