Display List on basis of selection

(0) Share

Report

Posted on by jsshivalik

3,099

I have created one C/al Global Selection which is of option Type . It has options Customer,Vendor. I want if user selects Customer then list of Customer Groups should get displayed in another dropdown . If Vendor is selected Then List of Vendor Groups should be displayed in that dropdown.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Check no. field tablerelation for reference in table 37/39

Was this reply helpful? Yes No
Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

First the drop down should be of type Code. Then go to the properties of this dropdown field and define the conditional relationship.

Was this reply helpful? Yes No
Suggested answer

Tina Menezes 2,582 on at

Like (0)

Report

Hi

You need to create a field for the drop down list to be displayed of type 'Code'. I have defined a field 'Result' below of type 'Code'. Now you need to set the table relation after navigating to the properties of the drop down field . You can check the screenshots below:

Now go to the properties of Result field and do the following:

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

I have written the below code in TableRelation but it is giving error - You cannot enter

If (OptionSet=CONST(Customer)) "Customer Posting Group" Else If (OptionSet=CONST(Vendor))"Vendor Posting Group" in FieldNo.

If (OptionSet=CONST(Customer)) "Customer Posting Group" Else If (OptionSet=CONST(Vendor))"Vendor Posting Group"

Thanks

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Jsshivalik,

Make sure OptionSet field is correct first, then you can input TableRelation for the Posting Groups field:

Was this reply helpful? Yes No
Suggested answer

Tina Menezes 2,582 on at

Like (0)

Report

Hi,

Make sure that your options in the option set string should be matching in table relation. Also instead of typing directly, it is preferrable to click the ellipsis button (...) at the right side of TableRelation and then enter the table relation.

Now click on OK

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

I am using Navision 2013 . When i click on ... nothing happens. In C/Al Globals i have defined OptionSet as Option DataType and Rtype as Code. Then on Request Page i have set the Table Relation in RType field.

Thanks

Was this reply helpful? Yes No
Suggested answer

Tina Menezes 2,582 on at

Like (0)

Report

Hi,

Do you want this customization to be done in a report or in a page?

The above method which I mentioned is for a page.

If you want this to be done in request page of a report you can refer my blog using the below link:

https://tinamenezes.wordpress.com/2017/08/16/displaying-lookup-form-on-a-field-based-on-a-particular-selected-option-of-another-field-in-request-page-of-a-report/

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

I want in a report.

Thanks

Was this reply helpful? Yes No
Suggested answer

Tina Menezes 2,582 on at

Like (0)

Report

Ok.

So refer the below link. I have done the same in a report.

https://tinamenezes.wordpress.com/2017/08/16/displaying-lookup-form-on-a-field-based-on-a-particular-selected-option-of-another-field-in-request-page-of-a-report/

Was this reply helpful? Yes No