Hi Jana,
Yep, I'm still hangin' out on the Community Forum ...
To do that you use the reverse relationship technique.
Assuming that you want to know the name of the customer who had the sales with the highest [Record ID#], on the relationship where 1 Product has Many sales you would do a summary maximum of the [Record ID#] field and call it
[Record ID# of the last sale]
Then do a new relationship where 1 sales has many Products, and on right side of the relationship, rather than letting Quick Base create a new field for you, use the field [Record ID# of the last sale]
Then lookup any fields from the last sale down to the Product, such as [Customer Name].
