>yes. i did the same method as well but the thing is the view cant take the general data type as i have picture for that.

Hi there,

If I am not mistaking, You can include General Fields in a SQL View but the Update Type should be set to 'Key Fields Only' in such a case.

Bye
Jayesh