Forum Discussion

Del's avatar
Del
Qrew Cadet
6 years ago

Relationship Help

I have a table called " Clients' "Assigned Providers" and "Providers". Clients connect with many "Assigned Providers" in which "Providers" may be selected - Assigned Providers is the joined table.

What I need is to be able to select a provider as well as select multiple "Services" from the provider - but the services are specific to each provider - 3 total types of services. One provider may have 1 out of 3, 2 out of the 3 and another 3 out of 3 services. Essentially, When assigning a provider to a client I want to be able to select multiple services that is specific to that provider.

------------------------------
Ermias Bean
------------------------------
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    This is no problem.  You can use what is called a Conditional Drop Down (CDD)

    To set this up the system needs to know which Providers offer which Service Types.  So you already have a table of Providers and make a child table under that table of the Service Types that they can provide.

    Then it sounds like you want to create a Child table under Assigned Providers to list the services being supplied.  So make that table and draw the choices based on a relationship to Service Types.  Then lookup the field for [Related Provider] down from the Assigned Provider down to the child table Assigned Provider Service and set the [Related Service Type] to be conditional on the previous selection of  Related Provider lookup.

    I hope I explained that well enough, if not, post back.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      6 years ago
      Thanks, performing this shortly

      ------------------------------
      Ermias Bean
      ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      6 years ago
      What do you mean by "So make that table and draw the choices based on a relationship to Service Types"

      ------------------------------
      Ermias Bean
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        You have the table of Assigned Providers.  I was assuming that there would be a child table under that one listing a record for each Service Provided.  So, when you add a record to select a service, then you need to have a drop down list of all the services provided from the Service Types table.  Once you have this setup, then the CDD will limit the drop down to just the services that the Assigned Provider is able to supply.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------