How to edit fields of two or more tables in 1 screen

This topic is locked

How to edit fields of two or more tables in 1 screen		11/22/2005 13:56:34
ASPRunnerPro General questions
author Hi Sergey and everybody. Does anyone of you know how can we edit fields of two or more tables in 1 screen? We use SQL Server and have try with a VIEW pointing to two or more tables but when try to save it shows 'dbo.vwNameOfView' is not updatable because the modification affects multiple base tables Is there any smarter way of working with multiple tables in same screen (NO 1 to may, NO Master Detail) (Yes 1 to 1). If ASPRunnerPro does not cover it is there a way of working around like joining two separate asp output files or anything else? THANKS, your help will be greatly appreciated. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2134&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />


	Sergey Kornilov admin 11/23/2005
	ASPRunnerPro assumes that you need just one "UPDATE" SQL statement per page. If you need to update more than table you need to modify ..._edit.asp file to execute as many UPDATE statements as you need. Another way - you can use triggers in your main table in SQL server to update second table automatically.