AnsweredAssumed Answered

Difficult Relationship Issue - summary and calculations

Question asked by cjl108 on Apr 27, 2012
Latest reply on May 1, 2012 by philmodjunk


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?