Forum Discussion
Hey try this by use of a well-crafted Formula-URL button on the parent record’s multi-page form. When the user clicks the button on Step #3 to add a child record, the formula should open the Add Record form for the child table and pass the parent Record ID# through the reference field. Most importantly, use the rdr (redirect) parameter to send the user back to the exact same page they were on after saving the child record. Here would be the formula structure:
```
URLRoot() & "db/" & [_DBID_CHILD_TABLE] & "?a=API_GenAddRecordForm" &
"&_fid_XX=" & URLEncode([Record ID#]) &
"&rdr=" & URLEncode(
URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&page=3"
)
```
This approach keeps the user experience smooth: they stay in the context of the wizard-style form and return to the step they were working on, instead of being sent back to Step 1. Test the formula thoroughly, and consider creating a helper formula field to store the redirect URL if you need to reuse it across multiple buttons.