Hi,

I have a list and calling a view on rowclick. The first time I select a row, a new blank record is created in a related table. if i delete that row (from SQL) and go back to the list and try again, the blank record is not created.

However the strange issue was when trying to see what's happening in the Table Watch Window when running in debug mode during (breakpoint on the OnConstrain Event).

The table gbPolicyType (2001) is showing columns from another table which is totally unrelated (which is not part of the view or any other related table) but showing the column description properly as shown (SMALL MEDIUM ENTERPRISE).

DF19.1 SQL

Thanks in advance.

Jesmond

Click image for larger version. 

Name:	gbPolicyType Columns.JPG 
Views:	48 
Size:	25.7 KB 
ID:	15146Click image for larger version. 

Name:	Strange issue.JPG 
Views:	50 
Size:	21.1 KB 
ID:	15147