Skip to main content
Question

Dropdown select from a related record

  • Feb 10, 2021 7:25 PM UTC
  • 0 replies
  • 40 views
Forum|alt.badge.img+11
Hi everyone,

I am building a table in my project management app to evaluate vendors.  In the vendors table I have a multi-select field with a list of services vendors provide.  As the vendor is added to the database the user can select what services they provide (it is not a separate table).

I have a relationship with each vendor has many vendor evaluations.

On the vendor evaluations table I want to have a field that displays the list of services that particular provides as a dropdown so the user can select which services they provided on this project.

Any ideas on how to do that?  I have a lookup field set but it shows all of the services the vendor can provide.  Now I want to set that essentially as a multi-select to clarify what they actually did do on the project.

Thanks in advance!

------------------------------
Ivan Weiss
------------------------------
This topic has been closed for replies.

The only way to do that is if the list of possible Services is setup as a separate table and then you have a Child table that is a Many to Many between Vendor and Services, called Vendor Services for this example. You can then create a relationship between Evaluations and Vendor Services and have the drop-down for Vendor Services setup as a Conditional Drop-down based on the selection in Vendor.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement