You’re offline. This is a read only version of the page.
How to use dependent dropdown in NAV 2013R2?
e.g. when we select state (like west bengal, madhya pradesh, assam, etc), city name is displayed corresponding to state.
my task is to select degree first then select semester
if degree is b.tech then semester will be 1-8
if degree is mba then semester will be 1-6
*This post is locked for comments
What I understood is that certain degrees can only be "done" in certain semesters.
If this is the case you should have a table named "Degree Semester" or something like that which contains at least two fields: "Degree Code","Semester" (both primary key).
If you have something like this, you could solve this by creating a table relation in the Semester field that is linked to that table and filtered by the Degree previously chosen. Something like this in the TableRelation of the Semester field:
"Degree Semester"."Semester" WHERE ("Degree Code"=FIELD("Degree Code"))
This would only show those semesters that match the degree.
For your requirement you need to have two tables
1. Degree (With Degree Value)
2. Semester (With fields being Degree and Semester value)
Then as Mohana mentioned on the table where you add Semester field set table relation to Semester table and use the condition.
For example check the customer table, Post Code field it depends the value based on Country/Region Code
Semester field should have a table relation with table filter with Degree.
You can check same example as reference in customer table
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (