Synchronize data in a matrix

[Former Member]

Hi all

I have a matrix in a sysform and I would like that data in it would be synchronized. I admit that I don't know how to begin.

I've created a usertable, a dbDataSource in my code, bound each cell of the matrix to a valid value of the dbDatasource, and now I'm there.

Shortly, this is the context: I edit ServiceContract form, and in the matrix I've created, I would like that data would be linked with the contractID.

Any help would be welcome

Thanks, Francois

Message was edited by: Francois Robert-Nadeau

[Trinidad · Accepted solution]

Hi Francois,

You will need to manage your db information by hand.

You want to save a matrix information per each contract ID.

So

When the form opens (form load event) or when the contractID form changes the data( next, previous,... buttons item_pressed events): You need to fill the matrix with the correct information regarding the current contractID shown. For that you need to do a DoQuery on the DBDataSources of your matrix (with the condition contractID) and after that call LoadFromDataSource() on your matrix.

When the user adds or updates a ContractID form and enters information in your matrix then you will need to read the information in your matrix (matrix.FlushToDataSource) and then write this information in your usertable (saving in your user table for each line the contractID that goes with).

The main points you need to have a look is how to work with a matrix in a form and catch the events you want to manage.

Hope it helps

Trinidad.

[Former Member · Accepted solution]

Tank you so much. I greatly appreciate your help !

François