I have a master layout where I am entering Books and multiple Subjects per book. One book has many subjects. Through a Find on this Master layout, I come up with a subset of records (Books and Subjects) that I need to run a Report on. My Report is another layout where I want to use the Found records to show each Book and its related Subjects. Each layout works perfectly by itself, but using a Button on the master layout to go to the Report (using GTRR or Go To Layout, etc.), the Report isn't using the Found set.

How do I get the Report layout to use the records I found using the Master layout? Thanks in advance for any help. While Filemaker is not new to me, this process isn't one I've tried to do before and I'm just not getting it.

whardy

Upon what table is the Master Layout based? You seem to have a simple many-to-many relationship, that calls for a join table in the middle of Books and Subjects. A sub-summary report from the context of the join table is a straightforward way to meet your requirement.

I think I tried to simplify my database too much in my explanation. It is clearly one-to-many, as the Subject side is actually particular occurrences of subjects in the Book. So, any record in Subjects will actually only refer to one book, not many. One book will many occurrences in it, though, of various subjects. As I mentioned, that part is all working okay and my question is more about how I get a report layout to use the same record set from the layout that contains the master database.

I hope that is a little clearer...

I hope that is a little clearer...

I am not at all sure about that, but I'll take a guess. I am guessing you want to produce a report of Subjects, based on the found set in Books. If so, it would be best to perform the initial find in the Subjects table (searching the related fields from the Books table).

Alternatively, GTRR [ Show only related records; Match found set ] will achieve the same thing, though probably more slowly.

I have tried GTRR with the Match Found Set, but I am not having success. There may be a setting that I still not getting right. GTRR seemed to be the most logical, but the report ends up with several times more records than the original found set.

Any other ideas? I will play with the GTRR settings since that still seems to be the solution.

but the report ends up with several times more records than the original found set.

Wouldn't that be expected, given that one book has many subjects?

I went back and started the GTRR from scratch and it worked as I originally thought it could/should and exactly as I needed. I am not sure what I got wrong the first time, but it is working now.

Thanks for the help thinking through it.