Adding Matrix Columns To the Pick List Manager

[Former Member]

Hi Everyone,

I'm trying to add a column to the pick list manager matrix. I know that one you can't add columns to a populated grid so I can clear the grid and add a column but the problem then comes with re-populating the grid. If I call Grid.AddRow it adds the last row again for as many times as I call AddRow (it doesn't loop though the dataset).

Notes:

1. I've tried the following methods and they don't work (Form.Update;Form.Refresh;Matrix.LoadFromDataSource)

2. You can't add a UDF to the Pick List Manager

Questions:

1. Is there a way that I can step though the data and add the rows again?

2. Is there another way of adding columns to the pick list manager?

3. Is there another way of refreshing the data on the screen?

Thanks in advance

Thomas Ellis

[FOA · Accepted solution]

Hi Thomas,

Do you refer to Form No. 85?

If yes, you can add UDFields to table PKL1 by using the PickLists_Lines object (New Object in 2005). In 2004 you can try adding the field using oUserFieldsMD.

HTH,

Felipe