Select a dimension code

Crunch

Sorry if this seems a silly question, but still trying to get to grips with dimensions.

I'm trying to make/run a report with (1 or more) Customer as data item. I would like to select a single dimension code among the dimension codes for customers from the request form. I made a textfield with source as dimCode - code and table relation to "Default Dimension".
I see the lookup button, but nothing happens when pressed.



EDIT: Added relation "Default Dimension"."Dimension Code" and code on OnLookup, so making progress:

IF FORM.RUNMODAL(FORM::"Default Dimensions",DefaultDim) = ACTION::LookupOK THEN BEGIN
DimCode := DefaultDim."Dimension Code";
//perhaps more here.
END;

David_Singleton

With out code, you can only do this with the 2 global dimensions.

mohana_cse06

Is there any reason for setting Default Dimension?

You can set Dimension in TableRelation and lookup also works..

Crunch

My endgoal is: Select a dimension. For one or more customers, set the value of the pre-selected dimension for each cust. in all their previous posted invoices, posted Shipments etc. to the current value of the selected dimension for each particular cust.
Hope that made sense.

mohana_cse06

Did you check with Dimension and Dimension Value tables in table relation property to reach your goal?

Crunch

Thank you very much for your input.
I just finally realized what the tables Dimension, Default Dimension, and Dimension Value truly represent in relation to each other.

I use Dimension as suggested, and it works, and my understanding is now in place as well. :thumbsup: