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.
:)
You need to have a relationship first. If you need to have the Maximum of a whole table just to get it for some reason,, the you will need ot set up sort of a dummy table and enter one record into it. It will be [Record ID#] of 1.
Then on the details table where you want to know the Max, you will make a formula field called perhaps [Link to max record table (=1)] and make it a formula numeric field with a formula of 1.
Then make a relationship where that 1 Max record table has many (in fact all) details records based on that link field used on the right hand side of the relationship.
Then make a summary field on that relationship for the max record ID. There is a button to make a summary field on the left side of the relationship.
Then do a lookup of that max field down to the child table and every child will know what the max record ID# is.
You need to have a relationship first. If you need to have the Maximum of a whole table just to get it for some reason,, the you will need ot set up sort of a dummy table and enter one record into it. It will be [Record ID#] of 1.
Then on the details table where you want to know the Max, you will make a formula field called perhaps [Link to max record table (=1)] and make it a formula numeric field with a formula of 1.
Then make a relationship where that 1 Max record table has many (in fact all) details records based on that link field used on the right hand side of the relationship.
Then make a summary field on that relationship for the max record ID. There is a button to make a summary field on the left side of the relationship.
Then do a lookup of that max field down to the child table and every child will know what the max record ID# is.