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. ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis 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
------------------------------
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
------------------------------
- Thanks, performing this shortly
------------------------------
Ermias Bean
------------------------------ - What do you mean by "So make that table and draw the choices based on a relationship to Service Types"
------------------------------
Ermias Bean
------------------------------- MarkShnier__YouYou 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
------------------------------- I have Providers, Assigned Providers, and SeVices Table. What able and i setting up the CDD field?
------------------------------
Ermias Bean
------------------------------
