Populating a Combo/Dropdown with data

lloydf

How can I populate a Combo/Dropdown on a form to data in a table

thanks

DenSter

Unfortunately, that's not possible. A combobox/dropdown list is populated by the optionstring property of an option type field/variable.

lloydf

Is it possible to build the optionstring variable dynamically by reading data from a Navision table?

If so could you please give me an example.

Thanks

LLoyd

Luc_VanDyck

Nope, that isn't possible either. The Optionstring-property is read-only.

lloydf

Does that mean that the optionstring value is always hard coded?

Luc_VanDyck

Yep, at design-time you decide the number of options.

lloydf

So there is absolutely no way of dynamically populating a combo box?

JedrzejT

Check this

This is not dropdown.. but this is some solution

http://www.mibuso.com/forum/viewtopic.p ... highlight=

Luc_VanDyck

lloydf wrote:

So there is absolutely no way of dynamically populating a combo box?

I will say this only once: No

Stefan_Verwey

Hi Lloyd

Just an alternative idea.

If you can spare a table, create a new table to host your list of variables and use a lookup to that that new table.

If you need to do the same for various reasons, use the same principle than used in Table 355 where Table ID & Dim Code etc are used within Filters when looking up the related applicable value needed.

Regards, Stefan

lloydf

Thanks for that Stefan
A good idea.Is it possible to create a table and structure it with a key to identify different lookups and filter on the lookup?
eg Hold multiple lookups in the one table with a specific key for each.

Lloyd

ivicaSD

I have found forum post with solution to this problem:

http://forum.mibuso.com/discussion/48486/dropdowns-in-request-pages-in-reports