Skip to main content
Question

Button to open form (on child table) from report (on parent table)

  • June 28, 2019
  • 0 replies
  • 62 views
Hello,

Hope you can help with this. I found a few related articles but can't seem to make the formula work.

I have two tables: Transactions (parent) and Notes (child). There is one note to one transaction.

I have a report on the parent table that lists transactions and I'd like to create a formula URL button on that report that opens the related note (using a designated form, "view" mode).

What would be the formula for this? 

Thank you!
    This topic has been closed for replies.

    So you want to open the the child from the parent? Simple way is to create a summary field in your relationship for the Max Record ID of your notes - which will return the record id of your note.

    Then for your url - something like this will work

    "
    Chayce Duncan | Director of Strategic Solutions
    (720) 739-1406 |     chayceduncan@quandarycg.com
    Quandary Knowledge Base
    • HALEYHALEY
    • Author
    • Registered
    • June 28, 2019
    Wow....this was so easy and works so well. Thank you!
    Terms & ConditionsAccessibility statement