|
Show data from master table on detail view/edit/add page.
To add this event use 
(Insert ASP code
snippet) button on the Visual Editor page.
 Note: Change the values listed in
red to match your specific needs.
Response.Write "Master Info<br>"
if Session(strTableName & "_masterkey1")<>"" then
set rstmp = dal.MasterTableName.Query("Masterkey=" & Session(strTableName & "_masterkey1"),"")
if not rstmp.eof then
Response.Write "Field1: " & rstmp("Field1") & "<br>"
Response.Write "Field2: " & rstmp("Field2") & "<br>"
end if
rstmp.close
set rstmp=nothing
end if
|
For example, Orders is
a master table, while Order
details is a details.
Response.Write "Order Info<br>"
if Session(strTableName & "_masterkey1")<>"" then
set rstmp = dal.Orders.Query("OrderID=" & Session(strTableName & "_masterkey1"),"")
if not rstmp.eof then
Response.Write "Customer: " & rstmp("CustomerID") & "<br>"
Response.Write "Employee: " & rstmp("EmployeeID") & "<br>"
end if
rstmp.close
set rstmp=nothing
end if
|
|
