Can we use Look up in Matrix Form.

panve11

Hi Experts ,

I want to enter a value in matrix column from look up. is it possible in navision
please suggest me .


Thanks & Regards
panvell

AAshok

Hi,

Have you tried with this trigger?

<Control1000000006> - OnLookup(VAR Text : Text[1024];) : Boolean

Control1000000006 will be a textbox in the matrix form.

panve11

i got a look up ,but once i select a value from look up ,entire matrix values changes with new value.my requirement is whenver i select a value from look up ,other matrix values shold not change.


Thanks & Regards

AAshok

Hi write the code as

- OnAfterValidate()
lookupvalue = 0;

make the field null where lookupvalue is the SourceExpr field for that matrix textbox.

Try this...
best of luck

panve11

HI AASHOK,

if i writeyour code , matrix form will be cleared
Actually we want to show the values in matrix form also . please suggest me



Thanks & Regards

garak

Take a look, for example, on form 113.

It's the same principle. You must only take some code snipes in the OnLookup Trigger of the matrixfield (if you doesn't have a table relation there). Also read the Developers Guide / Application Designer Guide. There are also some examples for matrix forms ;-)

Regards

AAshok

Hi,
Make use of any temp table to store the values in it at the time of validate and write the code in Onformat() trigger to show the value from the temp table.

try dis

lakshman

Hi AAshok,

i Took a temp table i am inserting in that table

can you suggest me for how to write code in on formate trigger for show values in matrix form.




Thanks & Regards

panve11

AAshok

Hi sorry for late reply.

MatrixEntry.RESET;
MatrixEntry.SETRANGE(MatrixEntry."Sales Order No.",OrderNo);
MatrixEntry.SETRANGE(MatrixEntry."Item No.",ItemNo);
MatrixEntry.SETRANGE(MatrixEntry."Hertical value",VerticalValueVar);
MatrixEntry.SETRANGE(MatrixEntry."Horizontal Value", HorizontalValueVar);
IF MatrixEntry.FINDFIRST THEN
Text := FORMAT(MatrixEntry.Quantity);

Plz check it and let me know if any.

Best of luck

Thank you
Ashok.A