>>>APPEND BLANK IN csrProjSessions >>>REPLACE IN csrProjSessions ; >>> csrProjSessions.ProjSessionsID WITH -1, ; >>> csrProjSessions.GroupID WITH this.Parent.Parent.nSelGroupID ; >>> csrProjSessions.VisitID WITH lnSelVisitID ; >>> csrProjSessions.ProjSessionsName WITH TRIM(this.Parent.Parent.cSelGroupName) + '-' + TRIM(lcSelVisitName) ; >>> csrProjSessions.ChoiceModifiedCol WITH CHOICEADDED >>>>>>I would also recomend to use INSERT INTO
>>>INSERT INTO csrProjSessions ; >>> (ProjSessions, GroupID, VisitID, ProjSessionsName, ChoiceModifiedCol) ; >>> VALUES ( -1, this.Parent.Parent.nSelGroupID, lnSelVisitID, ; >>> TRIM(this.Parent.Parent.cSelGroupName) + '-' + TRIM(lcSelVisitName), ; >>> CHOICEADDED ) >>>