A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Table/Relationship Indetermined



 
 
Thread Tools Display Modes
  #1  
Old July 2nd, 2009, 07:31 PM posted to microsoft.public.access.tablesdbdesign
Keli Alway[_2_]
external usenet poster
 
Posts: 9
Default 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!

  #2  
Old July 3rd, 2009, 02:17 AM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default Table/Relationship Indetermined

so Tbl_ActivityDetails has a combination primary key, made up of fields
ActivityCode and EmpID, correct? looks like this table is basically a class
roster, and you want to keep attendance records for each class, against the
roster. so add BOTH fields of the primary key to the attendance table, as
foreign key fields. so each attendance record will be linked to a specific
employee in a specific class.

hth


"Keli Alway" wrote in message
...

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.