Sometimes you need to redirect visitors to the details table (e.g., Order details) right after a new master record was added (Orders table).
The trick is to pass correct key field to the details table. Once user redirected there she can start adding details records using Inline or regular Add.
The following code needs to be added to AfterAdd event of the master table.
Response.Redirect "order_details_list.asp?mastertable=orders&masterkey1=" & values("OrderID")
In this example:
order_details_list.asp
the URL of the details List page;
orders
the master table name;
OrderID
the name of the key field.
See also: