Parent to Child Relationships
I am confused about parent to child relationships within a singular table. In my app "Competencies" I have a table for each type of staff. In my table for nurses, I track all competencies for nurses, ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis sounds like a classic Many to many Relationship.
One Nurse has many Nurse Competencies.
One Competency has Many Nurse Comptneacies.
So you need to create a new Table called Nurse Competencies. It will initially have no fields. Make your two relationships and then on the Nurses table you will be able to put the report link fields for that Nurses Nurse competencies (so a list of their competencies, and conversely, on the Competency table of the unique Skills you can have a report link embedded report of all the Nurse competencies for that skill, so a list of Nurse names.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
One Nurse has many Nurse Competencies.
One Competency has Many Nurse Comptneacies.
So you need to create a new Table called Nurse Competencies. It will initially have no fields. Make your two relationships and then on the Nurses table you will be able to put the report link fields for that Nurses Nurse competencies (so a list of their competencies, and conversely, on the Competency table of the unique Skills you can have a report link embedded report of all the Nurse competencies for that skill, so a list of Nurse names.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
