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
MarkShnier__You
Qrew Legend
Qrew LegendI will try to help you but first I'm trying to simplify your question.
You have these two Relationships
Goal < Metrics < Many Docs
ie one Goal has many Metrics and One Metric has many Docs. (Supporting Documents)
Can you confirm that those are your two relationships and also explain what the problem is?
Are you trying to automate the calculation of whether a Metric was achieved by if all of the supporting documents were achieved and likewise are you trying to auto calculate whether a goal was retrieved based on whether all of its metrics were achieved?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
You have these two Relationships
Goal < Metrics < Many Docs
ie one Goal has many Metrics and One Metric has many Docs. (Supporting Documents)
Can you confirm that those are your two relationships and also explain what the problem is?
Are you trying to automate the calculation of whether a Metric was achieved by if all of the supporting documents were achieved and likewise are you trying to auto calculate whether a goal was retrieved based on whether all of its metrics were achieved?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- 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
------------------------------- MarkShnier__Youif 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
------------------------------- Hi Mark!
Yes that is exactly what I am trying to do.
Thank you,
Sandralee Oster
------------------------------
Sandralee Oster
------------------------------
