This is a duplicate post: http://forum-en.filemaker.com/t5/Using-FileMaker-Pro/Is-GTRR-what-I-need/m-p/55470/highlight/true#M43539
I posted a reply to the original thread above. Does it work for you? If not, why not? (Your answer why not may suggest a better alternative.)
Sorry - After reading your answer to the other, I thought it over then realized it wouldn't work and forgot to come back to that post.
The reason I cannot base it on the Incidents/Visits is because it there are no incidents or visits yet, I cannot get a card to print for a given Household of FamilyMember, which is a requirement. A card with no incidents/visits actually provokes a visit in most cases.
I take it you need to see the data on visits if such have been made, but they may or may not exist.
Since this has to fit on a 4 x 6 card, basing the layout on Households with a portal to visits should work. You may need to establish a filter to reduce the number of visits listed so they fit on the card or something, but that approach will list all the visits for all family members of a given household.
I had originally tried the portal route, but the problem is that a visit may take up more than one line, so I need the portal to wrap. I asked a separate question about that and there didn't seem to be any really good solutions.
In the end I may be stuck have to convert the Visits to a notes field in the FamilyMembers database. I lose some functionality, but I cannot think of another good way to do this.
Thanks for the help,
I remember that post. We suggested a calculation that converted your portal rows into a list and placing that list in your layout in place of the portal. If you can get that approach to work, it might avoid the loss of functionality due to giving up the portal. I'm leaving and won't check back 'til Monday, but feel free to post a mock up of your 4x6 card if you'd like. Maybe someone or myself can suggest a way to make it work for you.