Hopefully I can get some help on this, I would greatly appreciate it.
So I have a book database app I am working on. There is two tables I am working with, BOOKS and SERIES.
BOOK table is a list of all book titles, there is a “Series” column in that table that REF to the SERIES table.
Basically what I want to do is reverse the REF.
To explain a bit more, I want when you click a title on the BOOK table for it to go to the book details and there be a virtual column showing the other books that are also in that series.
Here is an image of what I want it to look like. Is this something that can be done? I did a bunch of different things from the forum and the help center but kept receiving errors or weird results.
Thank you in advance for reading and let me know if further explanation is needed. Thanks!