Matrix form with editing abilities

Brad_Setzer

Hello,

I want to make it easier to assign mailing groups to contacts. I want do this by means of a matrix form, where all contacts are listed vertically and all unique mailing groups from table 5055 are listed horizontally.

I want the 'nodes' of the matrix to be presented by means of a check box. The purpose of the form must be that by clicking the right 'node' (the check box) a record in table 5056 (Contact Mailing Group) is created. Unchecking the check box must result in deleting the record.

What is the best way to achieve this ? Is there already a form in Navision that looks a bit like it ? I really hope someone can shine a light on this !

Best regards,

Brad

kriki

Check this:http://www.mibuso.com/forum/viewtopic.php?p=44846#44846
Especially this part : "In case you want an editable matrix :"

Brad_Setzer

Hello Alain,

I'm afraid you linked to this very message :-) Wrong link ?

Best regards,

Brad

kriki

Brad Setzer wrote:

Hello Alain,

I'm afraid you linked to this very message :-) Wrong link ?

Best regards,

Brad

:oops: This is the link (I had the wrong link in the buffer) :http://www.mibuso.com/howtoinfo.asp?FileID=13

Brad_Setzer

Superb. Thank you very much !

Brad_Setzer

Hi,

The creation of the form went well. The values in the matrix are booleans, so at the moment they are presented with the text YES or NO. Is there a way to replace this with a check box ?

Best regards

Brad

kriki

Brad Setzer wrote:

The creation of the form went well. The values in the matrix are booleans, so at the moment they are presented with the text YES or NO. Is there a way to replace this with a check box ?

I think it is not a problem. It is possible you have to change some code.

Brad_Setzer

I tried to replace the textbox on the right of the matrixform with a check box. Problem is that checkboxes do not have a OnFormat-trigger, and none of the available triggers is fired on the moment the checkbox is shown.

kriki

Brad Setzer wrote:

I tried to replace the textbox on the right of the matrixform with a check box. Problem is that checkboxes do not have a OnFormat-trigger, and none of the available triggers is fired on the moment the checkbox is shown.

In this case, put that code in "Matrix - OnAfterGetRecord()".