Display field of most recent child record?

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.

Wow, so impressive! I would NOT have thought of this. Thanks!!!

I tried this and I'm lost. I built a new simple app just to test this, but can't seem to get the Parents to display the highest numbered related status. Is there any more detail for this available?

Contact me via the information in my profile and I will have a quick look at your test app.

Thanks for the quick response. I found another response you wrote to a similar question, and that had enough for me to get it working.

I know that this is a very old post but I have a similar but more complex issue. I have a fact table that captures aircraft base locations on a monthly basis (the new monthly data is appended to the table). The table captures many aircraft and their locations every month, but I am trying to pull out only the latest location for each aircraft, which means that I'm only looking for the last input for each aircraft.

There is a new  type of summary field which makes this much easier now.

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])

OK, thanks I will give it a try.

OK, so I have run into another issue. When I try to create a Summary Field on my Parent Table (Aircraft table) from my Child Table (Location table), I am getting an error that states "you cannot create a summary field using a relationship where the reference field is a lookup field". The issue is that the foreign key in my Child Table (Location table) is set up as a look-up from the Parent Table (Aircraft table) so that the user doesn't have to remember the detailed Aircraft codes when inputting a Location. Is there any way around this or do I have to create a new input that requires the user to manually type in the Aircraft code every time they input the Location data?   

A possible work around, while not entirely clean... create a formula field which will have [Foreign Key] as the contents... use this new formula field to make the summary field. Same values, but technically not from the parent table to begin with.