Newbies jmobley Posted February 20, 2005 Newbies Share Posted February 20, 2005 Please excuse if this is too simplistic of a question... I've been building a project/task tracking db and I've just now tried to create some reports. Ulitmately, I want to see all my projects and their associated tasks in a printable report. I've followed the instructions in the FM help and in the "Sams Teach Yourself FM 7" book, but I'm having a heck of a time getting subsummaries to do what I think they should do. Even using the sample files from the "Teach Yourself..." book -- I keep having the same problem. Take Parties and Guest for example. One party can have multiple guests. There's a parties table with a field called "Event" and a Guests table w/ a field called "LastName". When I try to create a simple report w/ a subsummary part that sorts info based on Parties, and LastName is in the body, I get a report that only lists the first guest, but no others. The layout is based on records from the party table. The first break field is based on Events from the party table, then the body only has one field "LastName" (from guests table). Can anyone explain why this report only lists the first guest, but omits all the rest? Interestingly enough, I've even been able to show the reverse of this behavior. I switched the report so that it's based on a Guests table. The I sort on Events from Parties table in the subsummary. In this scenario, I get the first party with all the guests, but no other parties. So it seems that when running reports I can either show one party with all its guests, or all the parties, with one guest at each. (Again, the party/guest thing is just an example of behavior I seem to be repeating in other db files.) I'll happily answer questions if any of this is hard to follow. Please help. I've got to be able to provide project/task reports to a new client and I've been stumped on this for DAYS. Now I'm frustrated and demoralized.... **sigh** thx, Janet Link to comment Share on other sites More sharing options...
This topic is 6608 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now