Skip to Content
Former Member
Aug 18, 2005 at 04:08 AM

Creating and removing a user defined field



I added a User defined field in table PDN1 using the following code:

oUserFieldsMD.TableName = "PDN1" (Goods receipt row)

oUserFieldsMD.Name = "OB_Locn"

oUserFieldsMD.Description = "WH Location"

oUserFieldsMD.Type = db_Alpha

oUserFieldsMD.EditSize = 30

lRetCode = oUserFieldsMD.Add

The field was created in the database table. But i do not see the field appear in the form. Is it because, i should have added the field to Markiting Documents row?

If so how can i do so? Please help with sample vb 6.0 code.

Also please help with sample to remove the field that i created in PDN1.I do not know the id of the field that i created so i do not know how i can use GetByKey (to retrieve the field that i created) before removing it.