Forum Discussion

SandraleeOster's avatar
SandraleeOster
Qrew Trainee
4 years ago

viewing all child records when creating a child record from a parents record

Hi.  I have a parent table called cases and a child table called providers.  When they add a new provider to the case, they would like to see all the providers that are listed, choose one and have all related info about that provider auto populate.  A case has more than one provider. How to I set this up for when they go to add a provider from the child's table it lists all providers from the table?


------------------------------
Sandralee Oster
------------------------------
Relationships
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    You will need to have a middle or "join" table called like Case Providers.

    That's is because it's a Many to many Relationship.

    One Provider is used on Many Cases, but also One Case has many Providers.

    So you create that middle table called Case Providers and make these relationships.

    One Case has many Case providers.
    One Provider has many Case Providers.

    Mark


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • SandraleeOster's avatar
      SandraleeOster
      Qrew Trainee
      4 years ago

      Thank you!  I will make another table.

       

      Sandralee Oster

      Project Manager

      Office: 602-414-7562

      4755 S. 44th Place, Phoenix, AZ 85040

      www.MercyCareAZ.org

       

       

       



      NOTICE TO RECIPIENT OF INFORMATION:

      This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.

      This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information. Thank you