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
On that drop down list, I assume that it is being chosen off a relationship from another table.

Look for the field on the table probably called [Related Purchase Order].  Then there will be a checkbox on that field  for 

Conditional values The values in this field depend on a selection in another field

Check that box and make the drop down choices conditional on the [Related Vendor] the POs field for [Related vendor] matching the [Related vendor] chosen on the first drop down.