DOn't know how to make multi-field primary key work.

[khughes46]

I need to create a student roll report that shows Campus Name (there are 6), the session or period (AM, MID, NT), the classroom or SectionNumber (1, 2, 3, 4, 5, 7, 10, 11), the date (I use dateadd so we can print ahead), and the name of the person taking the roll. I get all I need except the Roll Takers name to appear in my Rolls Query. The Roll Takers table has three fields for the primary key that I am trying to relate to the Student Schedule table (see the relationships). But I can't get it to work. I obviously don't know how to properly use a multi-field primary key. DB is attached. Please help.

[June7]

Relationship between RollTakers and StudentSchedule is wrong in the relationship builder.

What you have is a compound key in RollTakers. This means need to have 3 links between StudentSchedule and RollTakers tables, not have StudentSchedule in the builder 3 times each with a separate link. One StudentSchedule table with 3 link lines to RollTakers.

Remove the 2 extra StudentSchedule tables and set the 3 links to the one table. Linking in query should be the same.

BTW, advise no spaces or special characters/punctuation (underscore is exception) in name convention.

[khughes46]

Did that and still no names.

[June7]

Campus_ID values are like 057828000. Cannot enter 1, 2, 3, 4, 5, 6 as parameter for the query. I used 057828002 and 30 as inputs and they worked.

I never use dynamic parameterized queries. I have user enter parameter into control on form and reference control in VBA to construct filter criteria and apply to form or report when opening.

DoCmd.OpenReport "Rolls Report", , , "CampusIDOfEnrollment='" & Me.cbxCampus & "'"

[khughes46]

I use a wild card to get my campus *1 *2 *3 *4 *5 *6, that works fine, and the days ahead parameter can be any number (positive or negative). That all works fine. But I'm still not seeing names in the Rolls Query. If I get names there I'll have them for the report. What am I not doing that you are to get names?

[June7]

After being sidetracked by the relationship issue, I lost track of the main issue.

The Campus_ID values in Roll Takers is only 8 characters. They are 9 characters in Campuses - there is a leading zero. CampusNumber field in Student Schedule has the 9-character version. No records from Roll Takers are matching the records in Student Schedule. Need to fix the data.

[khughes46]

Oh the difference a digit makes! Thanks again!