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 somewhere, but I've tried about five different searches to see where the answer for this question would be.
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.
1. Make a summary Maximum of the [Record ID#] of the locations table. call it [Record ID# of most recent location]
2. Look that up from the Aircraft down to Locations.
3. Make a new summary field of Combined text type to summarize the locations, subject to the filer that [Record ID#] = [[Record ID# of most recent location]
That will be the last location now up on the Parent Aircraft record.
That field will have a bubble-like format.
If that bothers, you, you can make a new formula text field field with the formula
ToText([my combined text summary field of the most recent location])