summergirl Posted February 15, 2005 Share Posted February 15, 2005 Here's the deal: File 1, Main, collects student demographic info. Data is also entered into 2 other files, Classes and Tests, via portals in Main. Students may have multiple records in the Class file, and multiple records in Test file. The key field for all 3 files is a single StudentID. I need a report that sorts by the ClassSite field (resides in the Class file) and displays StudentName and TestName (from the Test file). Attempt 1, in Class file: Created relationship ClasstoTest, matching the StudentID field in each file. Created report in Class file, putting the ClassSite field in a subsum part; StudentName(from Test file)in a subsum part; and TestName(Test file) in the body part. Sorted by Class Site, :StudentName. Result: Students are assigned to the proper class(es), but only the first TestName displayed. Attempt2, in Test file: Created relationship TesttoClass, matching the StudentID field in each file. Created report in Test file, putting related ClassSite field in a subsum part; StudentName (Test file) in subsum part; and TestName (Test file) in the body. Sorted by ::ClassSite, StudentName. Result: TestName shows up for each test taken, but the student is only listed once, under the first ClassSite in his record. For crying out loud, can someone PLEASE tell me what is wrong??!! Please type your answer s-l-o-w-l-y, and with lots of detail so I can understand the solution. Thank you in advance. Link to comment Share on other sites More sharing options...
This topic is 6606 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