Skip to main content
Question

Provide Link to New Record on Predecessor Record

  • May 13, 2025 3:23 PM UTC
  • 3 replies
  • 382 views

Forum|alt.badge.img+2

I've created a system where when a user clicks "Create New Agreement" URL button, a new record will be created that brings over key information, including the "predecessors" record ID so that the new record can capture that this previous agreement is a "predecessor". 

However, I'm trying to figure out a way on how to link the "predecessor" record to the newly created agreement as I want a user to actively see in the "predecessor" record that this work has already been completed. Any recommendations on how to do this? Thanks!

3 replies

Forum|alt.badge.img+6
  • Qrew Member
  • May 13, 2025 3:36 PM UTC

.


Forum|alt.badge.img+2
  • Author
  • Qrew Member
  • May 14, 2025 3:56 PM UTC

This worked, thank you. When I create this report link, the displayed Record ID hyperlinks out to the correct "successor" but it's showing the current record's Record ID in the field. While this isn't a problem because I can display a report that shows the successor record information, I'm now trying to create a separate QB report that will filter out any record that has an existing "successor". I'm trying to do this so that users will know what records still require action (e.g. if there is no successor linked to the agreement record and the agreement is about to expire, it requires action).


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 27, 2026 6:23 PM UTC

Since the new agreement already stores the predecessor's Record ID, you're one relationship away from this. Make a relationship from Agreements to Agreements, with the predecessor field as the reference field on the child side. That field needs to be numeric so it can hold a Record ID#.

Once that's in place, every agreement automatically gets an embedded report of the agreements that came after it, so the predecessor shows its successor right on the form.

If you'd rather have a single link, add a summary field on that relationship for Maximum of Record ID# (call it [Successor Record ID#]), then a Formula - URL field:

If([Successor Record ID#] > 0, URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([Successor Record ID#]))

One thing to watch: agreements with no successor show 0 in that summary field, not blank, so test for > 0 rather than "is blank". That same check works as a report filter to see which agreements have already been renewed.

Want more detail? I wrote a full walkthrough here: https://www.topstep.tech/blog/quickbase-link-predecessor-to-successor-record