Forum Discussion

Jay_DDS_'s avatar
Jay_DDS_
Qrew Cadet
8 years ago

Dropdown only showing certain options, possible?

I use several vendors, for jobs and when assigning a Vendor, I chose their name from a drop down.  After choosing the Vendor, I chose the purchase order that I will use to pay for the job from a diffe...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
no problem",

So if you make a field which is a concatenated formula field called perhaps [Related Vendor - Line of Service] put it on the form

List("-", ToText(Related Vendor]),[Line of service])

 and then if your make a similar field on your purchase orders, then you can make the [Related Purchase Order] field conditional on those two fields matching.  Be sure to put the the first concatenated field on the form so that the form sees it.  Once it is working you may be able to hide it with a form rule.