Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
No problem. You do that with a reverse relationship.
You probably already have a summary field on the Parent Property Record of the Record ID# which has the information you want.
Just make a reverse relationship where 1 Offer has Many Properties. Yes that feels backwards so it�s called a reverse relationship. But for the reference field on the right side of the relationship, do not let it make a new field, but rather use that summary field of the maximum Record ID of the Offer.
Then you can lookup any text fields form the Offer to the Parent Property
You probably already have a summary field on the Parent Property Record of the Record ID# which has the information you want.
Just make a reverse relationship where 1 Offer has Many Properties. Yes that feels backwards so it�s called a reverse relationship. But for the reference field on the right side of the relationship, do not let it make a new field, but rather use that summary field of the maximum Record ID of the Offer.
Then you can lookup any text fields form the Offer to the Parent Property