conditional dropdown on intermediate table

  • 39
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I have Vendors, Vendor Parts, and Inventory Parts

Each Vendor Part regardless of which vendor it belongs to, can be related to the same Inventory part. 

For example, Radioshack and Walmart both sell a flashlight with different part#. In my inventory I need it to be the same part# 

I have created the relationship to allow this, however, I am curious how I can go about creating a conditional drop down to select only vendor parts related to a specific vendor and also a specific inventory part
(once a user selects a related vendor, and a related inventory part.)

Can this be done with only two relationships Vendors<Vendor Parts>Inventory Parts  ?

Thanks
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb

Posted 9 months ago

  • 39
  • 1