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

Question

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

LauraThacker · Answer

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]

Sign up

Login to the community