Dropdown select from a related record
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
------------------------------
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
------------------------------
