I'm very late to the party but since I was looking for a solution to that exact same problem and couldn't find any, here is how I solved it :
- in the target table (the one being looked up), I created a new linked-records column called "self-reference". This column has the table targeting itself, with a dynamic filter applied so that each record can only target itself (in my case, i have a unique_id for each record, so I used "WHERE unique_id IS unique_id". This gave me a column where each record basically stores a link to itself.
- in the original table (the one I want to look up from), I created a lookup to the target table, with the appropriate filter(s) on any relevant field I want to filter by, and I set the "self-reference" field as the field being looked up and voilà.
