I suggest not using a Formula Query.
One Job has many Status updates.
- Create a Summary field on that relationship for the Maximum Record ID# and call it [Record ID# of Most Recent Status Update].
- Look up down to status updates.
- Create a Combined text summary field of the Status field on the updates table subject to the filter that the [Record ID#] equals the [Record ID# of Most Recent Status Update].
- That will give you the most recent status up on he job record. If you don't like the bubble appearance, then make a formula text field with the formula ToText([My combined text summary status field])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
