Display Master Table on Add/Edit Page

This topic is locked

Display Master Table on Add/Edit Page	5/19/2009 1:54:48 PM
ASPRunnerPro General questions
author I would like to display the master table info on the Add/Edit page. I tried copying just the block, but I think there is another piece of code based on a similar post for PHP. Can anyone tell me what I need to move in ASPRunner to make this work? Thanks much!


J	Jane 5/20/2009
	Hi, I recommend you to use custom event (Insert ASP code snippet option on the Visual Editor tab) to select values from master table. Here is just a sample: str = "select Field1,Field2 from MasterTable where Key=" & Session(strTableName & "_masterkey1") Set rstmp = server.CreateObject("ADODB.Recordset") rstmp.open str,dbConnection Response.write "Field1: " & rstmp("Field1") Response.write "Field2: " & rstmp("Field2") rstmp.close set rstmp=nothing