I'd like to have a button on my main table that when clicked to shows the record on at a related table.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

My main table is all of our client records.  I 'd like to hit a button that will open their billing entry that's on a related table.   Any formula ideas?

Photo of Tony

Tony

  • 226 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
So is the setup that 1 Client has many Billings entries?  And you want to click a button on the Client to display a report of all their Billing records?
Photo of Tony

Tony

  • 226 Points 100 badge 2x thumb
Basically.
Before I give the slightly complicated answer for a formula, why not just put a report link field on your Client Record to show a report link to the billing records or an actual embedded table of the Billing entries right on the client record?  The report link field will have been created for you on the left side of the Relationship between Clients and Billings
Photo of Tony

Tony

  • 226 Points 100 badge 2x thumb
Thank you.  I saw that and wasn't entirely sure how to use it.  I figured it out now.  Thank you again!
Great, stupid simple is always the way to go when available!  No need to write formuals that way.