|
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.Table("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.Table("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
|
For more information about using Data Access Layer (DAL), see
Data Access Layer.
|
