Showing ""Current "" status on a record
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 "Supp...
Forum Discussion
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.
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.