There is not a way to make it behave differently with a simple setting.
But if you go back to that relationship and lookup that summary maximum date down to the child records, you can then create a new summary field to obtain the maximum [Record ID#] of the children where the date matches that Maximum date.
Then you can make a formula URL button to click on to directly edit that record.
The formula would be like
URLRoot() & "db/" & [_DBID of the child table] & "?a=dr&rid=" & [Record ID# of child with maximum date]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com------------------------------
Original Message:
Sent: 11-19-2019 12:05
From: George Bramhall
Subject: Open a record automatically in edit mode
------------------------------
George Bramhall
Original Message:
Sent: 11-19-2019 09:39
From: George Bramhall
Subject: Open a record automatically in edit mode
My report Link is in a report, not on a form. The link opens a record in a child table. It only opens in view mode., would like it to open in edit mode without the user having to anything.
------------------------------
George Bramhall
Original Message:
Sent: 11-18-2019 19:36
From: Mark Shnier (YQC)
Subject: Open a record automatically in edit mode
If you set the form to display the records directly on the form as an embedded table, then the user can decide to open individual records in View or Edit Mode.
In addition, you may choose to set the form property for the embedded report to be "editable" which would allow the users to to edit the child records in Grid Edit mode while editing the parent record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
Original Message:
Sent: 11-18-2019 19:32
From: George Bramhall
Subject: Open a record automatically in edit mode
I am clicking on a report link and it is going to a single record in view mode. How do I get it to automatically open in edit mode.
------------------------------
George Bramhall
------------------------------