Discussions

 View Only
  • 1.  Parent to Child Relationships

    Posted 01-18-2022 12:10
    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, however, I want to make it that each nurse competency type has many of the same types. Would I be able to make a parent to child relationship for the fields within this one table. If so how would I be able to do this ?

    ------------------------------
    Campbell
    ------------------------------


  • 2.  RE: Parent to Child Relationships

    Posted 01-18-2022 13:21
    This 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
    ------------------------------