Need help with relationships
Hi I need help to finish configuring my database The Details: Each goal has many metrics
Each metric has many supporting documentations
I have a many to many table setup for this relation...
Forum Discussion
Hi Mark,
The relationships are correct. I also have a relationship in the document review table where document review > Supporting documentation.
Sorry I should have explained what I am needing better. I need help in creating all the relationships to tie the supporting document reviews to the metrics and those metrics to tie in with the goals. I don't need it to calculate the goal automatically as the manager wants to do this manually. Once the supporting documents for each metric has been reviewed by the business owners, the manager needs to then give an overall rating on the metrics based on all of the supporting documentation. Then once he has the ratings for all the metrics that are related to the goal, he has to do another rating for the goal.
------------------------------
Sandralee Oster
------------------------------
The relationships are correct. I also have a relationship in the document review table where document review > Supporting documentation.
Sorry I should have explained what I am needing better. I need help in creating all the relationships to tie the supporting document reviews to the metrics and those metrics to tie in with the goals. I don't need it to calculate the goal automatically as the manager wants to do this manually. Once the supporting documents for each metric has been reviewed by the business owners, the manager needs to then give an overall rating on the metrics based on all of the supporting documentation. Then once he has the ratings for all the metrics that are related to the goal, he has to do another rating for the goal.
------------------------------
Sandralee Oster
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendif you gave the relationships in place then this is done
I need help in creating all the relationships to tie the supporting document reviews to the metrics and those metrics to tie in with the goals.
Are you in fact asking how to show the various embedded child tables on the higher level parent forms?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I need help in creating all the relationships to tie the supporting document reviews to the metrics and those metrics to tie in with the goals.
Are you in fact asking how to show the various embedded child tables on the higher level parent forms?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------