Hi everybody,

I have a form with the TreeView on the left (based on TList from bennet-tech) and pageframe with 10 pages on the right.

In one of the pages I only have an Add button. This is the code in this button:

LOCAL lnVenueID
thisform.lAdding = .t.
SELECT rsTemplates
APPEND BLANK
lnVenueID = thisform.VenuesTree.ItemValues(thisform.LastSelectedIndex,'VenueID').Value
replace VenueID WITH m.lnVenueID
this.Parent.Parent.ActivePage = 9 && Template Edit  
this.Parent.Parent.pagTemplateEdit.txtDescription.SetFocus()

The controls on the Template Edit page are bound to rsTemplates' fields.

However, for some mysterious reason the EditBox for Notes shows the unrelated record note, not the blank.
Do you know if I need to do something? May be to be sure I just need to assign blank value to this?

Also, this field originally came from the Text type field in SQL Server. I already suggested to get rid of them and switch to varchar(max). We're using SPT with ODBC - will it work fine?

Thanks in advance.