Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
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.