How can I select multi values from Dimension Value Table.
I can have a text field with “ClearonLookup” property set to No. Then the problem rises when I select same combination with different order (a,b,c = c,a,b). Since I set the field’s data type as field I’m facing the ordering issue.
How can I make multi selection that orders by dimension value’s code and return me 1 string?
By default then the system will always display the dimensions in the order of the value. So it will always be A, B, C and not C, A, B. The reason is that the typical fields in dimension line tables are Dimension Code and Dimension Value. To do what you are requesting it would require an additional key field, ex. Line No.
First of all I have not much experience on Navision. And I don’t know how can I select multiple lines at a time, so I made it like totaling in charts of accounts.
So, the problem rises because people not alway go from the top to the bottom.
If there is a way to choose multi lines at a time please give me a hint.
I don’t want to do as report 91 does. I like the idea but it is going to take 1 more table with it.
There are some ways of doing this. Take foir instance a look at standard form 22 (Customer List); there are two functions: GetSelectionFilter and SetSelection.
To use GetSelectionsFilter do like this:
(foCustList points at form 22; txFilterStr is a text-variable)
IF foCustList.RUNMODAL IN [ACTION::LookupOK, ACTION::OK] THEN BEGIN
txFilterStr := foCustList.GetSelectionFilter;