Showing "Current " status on a record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a couple of tables and a linking table that I am working with and trying to utilize to pull data for a field back to one of the parent tables.

"Accounts" (table) may have one or more "Supplier Contracts" (table) , but never more than one at a time. I have a linking table that allows me to show for each account what Supplier Contracts have been associated with that account over time and for each Supplier Contract if the status is current, future or expired.

At the Account record I would like to show the current Supplier Contract so I can use it in other areas of the App.

Seems simple, but I can't figure out how to do this.

Tony A.
Photo of TonyA1

TonyA1

  • 100 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
No problem,

This is a simple and classic need for a reverse relationship.

On the relationship where 1 Account has many Supplier Contracts make a Summary of the maximum [Record ID#] if the Supplier Contracts subject to the filter that the Supplier Contract is Status Active.  Call this [Record ID# of the Active Supplier Contract]

Then maker a new, so called, reverse relationship where 1 Supplier contract has many Accounts.  But as you are setting that up, do not let Quick base create a new field for you on the right side, but rather select the field called [Record ID# of the Active Supplier Contract].

Then just lookup any fields you like from the Active Supplier Contract to the Account.
Photo of TonyA1

TonyA1

  • 100 Points 100 badge 2x thumb
Mark...this works great!   Thanks!!

Tony