Click a button in email notification to change field in different table

Please post you code for the button and the error

URLRoot() & "db/" & [_DBID_Contracts] & "?act=API_EditRecord&rid=" & [SAP Contract #]

& "&apptoken=b9pzvpjdbfk42zck9xawjk99nx5"

& "&usertoken=b27z4b_xfm_b57dsvw279ijqcf93f6cdaj7y4f"

& "&_fid_282=true"


ERROR Code:
<qdbapi><action>API_EditRecord</action>
<errcode>30</errcode>
<errtext>No such record</errtext>
<errdetail>
Sorry, there is no record in this application table with the record identifier (rid) of "800275310".
</errdetail>
</qdbapi>

To edit a record you need to specify the record I'd or the key field value.


There is no way that you have a Record ID of 800 million. So either you need to change to this


&rid=" & [Record ID#]


Or else


&key=" & [SAP Contract #]


If that SAP Contract was the Key field.

I changed it to &rid="& [Record ID#] and got the error:
Sorry, there is no record in this application table with the record identifier (rid) of "5

The button is on table A. But you want to edit a record on another table, table B. Which record do you want to edit? You need to specify either the record ID number or the Key field of table B.

Once that works you will then have to decide where you want to leave the user or else the system will put up a success message in the screen which you will want to suppress.

I want to edit table B. The Key field for both of the tables is the Record ID#. 

There are lots of records in table B. Which one do you want to edit.

the contract number was pulled in from the table B to table A (where the button is). I want to edit the record with that contract number. 

You can only edit a record if you know the Key field or the Record ID. You would need to be willing to change the Key field in stable B to be the SAP #.

So I was able to get the checkbox to work (I just pulled over the record ID# from table B instead of changing the key field). EXCEPT, I get an ugly error message when I click the button. The error message is:
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>1991</rid>
<num_fields_changed>1</num_fields_changed>
<update_id>1501208116824</update_id>
</qdbapi>