Using SQL Views

Hi Ray,
I'm not sure if it's "best practice" but there are 2 methods I use for this. One is to use the "Custom add"/"Custom record update" events and create my own insert/update statement(s) into the table(s) that need to be altered. Like this:
string sql = "UPDATE [dbo].[MyTable] SET [MyField] = '" + values["FormField"].ToString() + "' WHERE ID='" + oldvalues["ID"].ToString() + "';

CommonFunctions.db_exec(sql, null);
return false;
The second method works if you only need to add/update one underlying table but are showing fields (via the view) on the add/edit page from another table. In this case, in the "Before record added"/"Before record updated" event I add "values.Remove("NameOfField");" for all of the fields that aren't in the underlying table I want to affect. As long as all the fields that are getting added/updated are from one underlying table, this seems to work.
Hope this helps.

Good luck.

Tim

Tim,
This is a slick method, simple and effective. I will try this implement this weekend.
Many thanks

Ray