Display field of most recent child record?
Parent table: Computers I want a field in this table to reflect the most recent "status" that was entered for each child record in a Statuses table. I'm sorry -- I'm sure this has been answered som...
Forum Discussion
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.
Thanks!
I realize it is much different from what I would have done on excel/matlab..A whole new philosophy to embrace ;-)
I have done my homework and managed to retrieve the latest status which was my initial intend. Thanks a lot for the explanation!
I realize it is much different from what I would have done on excel/matlab..A whole new philosophy to embrace ;-)
I have done my homework and managed to retrieve the latest status which was my initial intend. Thanks a lot for the explanation!