Skip to Content
0
Former Member
Feb 14, 2007 at 02:05 PM

Updating and Loading a Matrix Row with Mix of DB and Non DB fields

17 Views

Hi

I'm using SAPB1 2005 SP1 PL14 with B1DE 1.3

I have a matrix on a form that was generated by the UDO Form Generator. The Matrix contains data associated from a Document Lines table.

The underlying table and (therefor the matrix as well) only had 1 user field (column)

I've added a set of additional (read only) columns to the matrix together with supporting non db user datasources for each column. I've bound the new columns to the user datasources.

The new columns are only informational and should display data associated with the actual db field (column) in the matrix.

I require assistance / advice with 2 requirements:

<i>Requirement 1.

When loading the matrix, I'd like the non DB columns to be populated with data associated with the actual DB field.</i>

<i>Requirement 2.

When Adding / Updating the actual DB field in the matrix, I'd like the Non DB columns to be populated with the assocaited data.</i>

I've managed to get requirement 2 working by using a matrix onValidate Event. (not sure if this is the best approach?)

Any idea how I can achieve requirement 1 ?

Cheers,

Ben