Button to open specific field in a different table

Kelly,

If the template ID is to be updated in the other table - I'd create a button that would execute API_EditRecord to update a check box/timestamp in the other table where the template ID is present with the redirect URL pointing to the edit form of the other table. This will help to redirect to the table form where the template ID needs to be selected.  A dynamic rule needs to be added in the other table to make the template ID field mandatory when the checkbox is checked.

If a new record is to be created in the other table, then I'd just simply redirect to the add form of the other table with template ID by specifying the URL that ends like a=API_GenAddRecordForm&_fid_7=1 (field with ID 7 is a checkbox field that can be used to set the template ID mandatory when the checkbox is checked).

Thanks,

Dinesh Vijayakumar