Drop Down List on a Page textbox using Add-Ins

zimworxcode

My client uses Dynamics NAV 2009. I need a text box to drop down a list of suggestions, say of names starting with values being typed by the user. For example, if a user types Peter, there must be a drop down that gives a list of suggestions of Peter names in the database.

I believe it should be possible with the Add-In property of text-boxes by passing a list of values from NAV to the text-box.. so as the user types in values the search results are displayed in the Add-in text-box as a dropdown list.

Or Is it possible to achieve this in Dynamics NAV 2009? How can i achieve this function?

Thank you in advance.

skulla

I believe you want to use the Names field as a LookUp field in another table and pull out the suggestions as the user types in the text box. If you have separate table to stores the names and if the name field is the key in that table and if you create a new field in another table which will lookup the names table then standard navision table relation propery will do it.

If you requirement is different then please let me know.

zimworxcode

Thank you for your response.

The requirement is as follows.

a) Customer requests a quotation

b) Sales Person Captures Customer detail and item detail.

c) if Customer name is in the database, customer fields on Quotation should be populated automatically. Else Sales Person has to capture all Customer fields manually. My client does not want to create an account for everyone who request a quotation yet do not bring business.

Now how would one determine fast if someone is already in the database? Using a lookup then a manual search was not acceptable. I thought Typing a name say Peter, then i get a dropdown list (like intellisense) of all Peter names in the database. This way i can determine whether the client is already in the database or is a new client. If it is are a new client a Customer Account is only created once they bring business that is converting the quote to an Order.

skulla

When you create a quote, in the Sell-to Customer Field drop down you can click on the Name Field and start typing the name, it will filter the customer list.

Please see the attached screenshot.