I’m trying to pull in a list of all other books a group has checked out previously. The formula that is working in another doc is to use a lookup to my Book table. Then the formula:
[Checkout Log].Filter([Book Group]=thisRow AND Book!=thisRow.[Current Book]).Book
For my new document), writing a similar formula doesn’t work. My original doc is almost identical to the current one. My end game here is that I’ll then be able to create a table view in the Detail display for this Book Group. I.E.
The document I’m working in: