How to pull history in from other table

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:

Dear @agoodman,

I saw you reacted in the past to this post, did you concern it the method?

Credits to @Krunal_Sheth

1 Like