Difficult Relationship Issue - summary and calculations
So I have been trying to wrap my head around something and can't quite figure it out. I have a library/inventory database I have been building and so far, with all the info I find here in the forums, I have found the answers I need(thanks for that)... until now!
My database is set up as so:
So I have a Set of 5 books in a series(ABC) that may have 3 sets and other single books. (not all sets are in a series and not all series have sets)
In this particular set, the series volume numbers are 121-125, and from a Set layout, I wanted to use a summary and/or calculation field to say "Set of 5 books in the ABC Series, volumes 121-125"
I was able to use a summary field in the BOOK table to get the number "5", but am unable to get the #s 121-126.
Any ideas out there?