Forum Discussion

VivekVishwanat2's avatar
VivekVishwanat2
Qrew Cadet
6 years ago

Button to open the form of related record in the child table.

Hi,
I have Table A and Table B. 

I want a button in Table A  to redirect to table B.

 --> this Button in the form of Table A, should redirect to the existing record in Table B and should open the respected record in the Edit mode.

The problem here is "API_GenAddRecordForm" in the Button create a new record.
I don't want to create a new record in Table B, but need to update the Existing record in Table B, when the Button is clicked.








Please Help





APIs and custom code
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    You can use a summary field to get the Minimum [Record ID#] from table B into Table A.

    Then simply modify the default [Award Contract] button to display:

    If ( > 0,
    URLRoot() & "db/" & [_DBID_TABLE_B_NAME] & "?a=er&rid=" &
    ,
    URLRoot() & "db/" & [_DBID_TABLE_B_NAME] & "?act=GenAddRecordForm&....."

    1. the second line should be the same as your current formula that adds a new record
    2. The table alias needs to be the same as your existing Add button formula instead of [_DBID_TABLE_B_NAME]