Thank you for responding. What I’m trying to do is have three tables connected (Book, Borrower, Borrowing History). Therefore, when you look at the book Layout display, you get a nice embedded table showing the list of previous borrowers (in descending order). For e.g.
Borrower ----- Date Borrowed
If I don’t add .first(), I get the bad dates shown above. But if I do, I get the date for the last book borrowed that person took out – even if it isn’t for this particular title. I’ve tried to modify the formula to refer to this title, but that gets me nowhere either.
I appreciate any pointers.
By the way, you wouldn’t have a guess as why the Borrowing History table that is embedded in a Book row will display as a table most of the time, but not always? In one of my Books, the Borrowing History shows up as a list of tags. The code is identical in all cases…