Master table on edit and add pages

Hi,
use custom event (Insert ASP code snippet option on the Visual Editor tab) for this purpose.

Select and print master details in this event. Here is 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 "Master Table" & "
"

Response.write "Field1: " & rstmp("Field1") & "
"

Response.write "Field2: " & rstmp("Field2") & "
"

rstmp.close

set rstmp=nothing

Thanks, Jane! I'll give it a try.

Hi,

use custom event (Insert ASP code snippet option on the Visual Editor tab) for this purpose.

Select and print master details in this event. Here is a sample: