Table list views

This topic is locked

Table list views	2/17/2009 10:31:09 PM
ASPRunnerPro General questions
K kwilsokl author Not sure how to ask this. I have 2 tables(pages) in ASP runner 6 from an SQl database. I would like to make one (table)page a child of the other. SO for example in my list page of the first table I would like to add the list data of the second table. SO both table become one page. So again sorry it is hard to articulate. But due to one to many relationsships where the tables are normalized. I want to combine both tables or list pages as they are in asprunner into one page where users can view and add new records


J	Jane 2/19/2009
	Hi, to combine two tables on the list page edit SQL query on the Edit SQL query tab. Use Inner Join clause for this purpose. Unfortunately ASPRunnerPro doesn't support updating multiple tables on one page. You can implement this manually using Before record updated/added events. I.e. use something like this: sql = "update joinedtable set Field1='" & dict("Field1") & "' where RecordID=" & keys("RecordID") dbConnection.Execute sql dict.Remove("Field1")