Re: Display field of most recent child record?
:)
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.
