Skip to main content
Question

Button to go to related record in a different table

  • Jul 9, 2025 8:57 PM UTC
  • 2 replies
  • 106 views

Forum|alt.badge.img+4

Hi,

I have 2 tables, I would like to add a button in the form from the Accounts table that takes me directly to the related record in the Findings table. Both tables have the same Account ID field so I have created a table to table relationship between the two. I'm assuming I can achieve this with a url field with a formula that some how finds the related record in the Findings table by matching the account ID# but I have no idea what that formula would be. Please help

Thanks

2 replies

Forum|alt.badge.img+19
  • Qrew Champion
  • Jul 9, 2025 9:10 PM UTC

If you have related the two tables, the Child Table will automatically get a field to the Parent Record.

Here is a picture from a relationship.   

The field Related Parent and Parent-Name should both be links back to Parent.

If I misunderstood your question, please expand.


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 26, 2026 10:49 PM UTC

Since the relationship already exists, the link back to Accounts on the Findings side is automatic. Going the other way from Accounts to Findings needs one extra field, because a parent can have many children.

 

On the Accounts table, add a summary field through that relationship using Maximum of Record ID# from Findings. Call it something like [Max Finding Record ID#]. If there's only one finding per account, that's the finding's ID.

 

Then add a Formula - URL field on Accounts:

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