If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table/Relationship Indetermined
Hi I am setting up a database to keep track of our training classes. I have
to track absences and count them for the week as well as a cummulative count. When I am doing the cummulative count, it is counting all the absences for their past classes and their current class. I think there is something wrong with one of my tables. Tbl_Associates -Emp ID - Primary Key -Last Name -First Name Tbl_Activity Info -Course Title (there are 3 courses) -Activity Code (Individual code for the particular class) - Primary Key -Instructor Name -Location -Start Date -End Date Tbl_Activity Details -Activity Code - Primary Key & One to Many relationship with Activity Info -Emp ID -Primary Key & One to Many relationship with Associates -PC# -DN# -Status (Complete, Incomplete, Drop) -Withdrawl/Drop Reasons Tbl_Attendance -Emp ID - Primary Key - I feel like this should link to Tbl_Activity Details but I get an Indetermined Relationship. I can link it to the Associates table, but then when I go to count absences I can't count the total absences on just this Activity, I get all activities they have been in. -Date -Primary Key -Week # -Late -Late From -Absent -Preplanned -Time missed Any ideas on how to fix this so I can group the attendance by the Activity Code? I also have Weekly Progress reports that have to be done every week per Activity and when I create my form, it get the reports for all activities, not just the activity code I have them enter in the query. It's pretty much the same problem, just different info no being able to group by Activity Code. Please help! |
Thread Tools | |
Display Modes | |
|
|