Hi,
I am trying to figure out where to put the ChecklistItemInfo table (red border) in my relationships. I have tried it 15 different ways but can't quite seem to get it. See the image for the realationships that I quickly created in Visio. Please disregard the arrow from the Project table to the Checklist table.
There are many Projects and several Checklists. I created a junction table since a Project can have many checklists, and a checklist has have many projects.
Each checklist has many checklist items (number, description,...) so the ChecklistItemInfo table was created with a one to many relationship (red arrow).
For each checklist for a project (Project_Chklist table) there should be some input in the ChecklistItemInput table for each ChklistItemNum in the ChecklistItemInfo table.
My question is where to put the ChecklistItemInfo table, and how to relate it to the ChecklistItemInput table. I had the ChecklistItemInfo table to the right of the junction table but I believe that was creating redundant checklist item info. And putting the ChecklistItemInfo table to the left of the junction table I was not sure how to relate the ChecklistItemInfo table to the ChecklistItemInput table. I thought someone might be able to steer me in the right direction on this relationship.
Table relationships link on DropBox (I hope this works)
https://www.dropbox.com/s/9zc15ydlu18xiuf/2015-01-28 09-20-10_BIQMetricsRelationship.jpg?dl=0
Thanks.
I am trying to figure out where to put the ChecklistItemInfo table (red border) in my relationships. I have tried it 15 different ways but can't quite seem to get it. See the image for the realationships that I quickly created in Visio. Please disregard the arrow from the Project table to the Checklist table.
There are many Projects and several Checklists. I created a junction table since a Project can have many checklists, and a checklist has have many projects.
Each checklist has many checklist items (number, description,...) so the ChecklistItemInfo table was created with a one to many relationship (red arrow).
For each checklist for a project (Project_Chklist table) there should be some input in the ChecklistItemInput table for each ChklistItemNum in the ChecklistItemInfo table.
My question is where to put the ChecklistItemInfo table, and how to relate it to the ChecklistItemInput table. I had the ChecklistItemInfo table to the right of the junction table but I believe that was creating redundant checklist item info. And putting the ChecklistItemInfo table to the left of the junction table I was not sure how to relate the ChecklistItemInfo table to the ChecklistItemInput table. I thought someone might be able to steer me in the right direction on this relationship.
Table relationships link on DropBox (I hope this works)
https://www.dropbox.com/s/9zc15ydlu18xiuf/2015-01-28 09-20-10_BIQMetricsRelationship.jpg?dl=0
Thanks.
