Dynamics Community Forum Thread Details

Create dynamic DropDown

I would like to create a dropdown menu where I can select addresses.

Only addresses that have been entered for the customer should be displayed. This means a customer can have one or more addresses.

Currently, the following is in place.
The address designation is declared as an option (home address, billing address, mailing address, secondary address) in my table field and is stored in the database as a number in my customer table along with various customer details.
There is also a CustomerAddress table where the corresponding option is stored as a number, along with the address details.
I select a customer from a list and am taken to the Customer page. From there, I call up another page via an action. Before doing so, I call the SetParameter procedure of the second page and pass the customer’s record as a parameter.

Now I have two scenarios.
The first one displays a list of customer addresses in the dropdown, but I always get a message saying, “Your change may update related records, which may take a while. Do you want to continue?” when I select an address from the list.
This message is annoying and irrelevant, since I fill in additional text fields with the address data when selecting the address.
These fields are only displayed and are not edited or saved. I am working with SourceTableTemporary and a TableRelation named CustomerAddress.

Scenario two is that I try to get by without a SourceTable on the page, but that doesn’t work properly—the dropdown is always empty.

Is my plan even possible, or do I need to take a different approach?

I am new to programming. I would appreciate any suggestions.

Thank you.

Categories:

Dynamics 365 Business Central

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS