Forum Discussion
QuickBaseCoachD
Qrew Captain
Make a summary field of the maximum of the Record ID# of the child status table records called [Maximum Record ID# of status records]
Make a new relationship where 1 Status is related to Many parents - ie a reverse relationship and the reference field at the right side will be that field [Maximum Record ID# of status records]
Then just do a lookup of the Status from the Child to the Parent. but QuickBase will see it as a lookup from a parent to a child.
Make a new relationship where 1 Status is related to Many parents - ie a reverse relationship and the reference field at the right side will be that field [Maximum Record ID# of status records]
Then just do a lookup of the Status from the Child to the Parent. but QuickBase will see it as a lookup from a parent to a child.
FrancescoGallar
2 years agoQrew Member
Hate to bring back an old thread but the approach described works only with record IDs or can it be done with other fields as well?
For example if I want the most recent item from the child table based on a date field is there a way to do so?
------------------------------
Francesco Gallarotti
------------------------------
For example if I want the most recent item from the child table based on a date field is there a way to do so?
------------------------------
Francesco Gallarotti
------------------------------