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 op...
APIs and custom code
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
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]