|
To update two joined
tables:
1. Use the following code
in Add page: Before record added
and/or Edit page: Before record updated
events.
 Note: Change the values listed in
red to match your specific needs.
sql = "update othertable set joinedfield=" & values("joinedfield") & " ... "
dbConnection.Execute sql
values.Remove("joinedfield")
|
To update master and details
tables:
1. Use the following code for joined table in Add
page: Before record added and/or Edit page: Before record updated
events.
dal.othertable.Param("fieldname")=values("fieldname")
dal.othertable.Value("joinedfield")=values("joinedfield")
dal.othertable.Update()
values.Remove("joinedfield")
|
2. Use the following code for details table in Add Page: After record added and/or
Edit page: After record
updated events.
dal.detailstable.Param("detaillinks")=oldvalues("detaillinks")
dal.detailstable.Value("detailfield")=values("detailfield")
dal.detailstable.Update()
values.Remove("detailfield")
|
|
