I have customer table that has many locations. When I create a new project it is assigned a customer. Then I create part numbers inside that Project. Each one of those part numbers may be shipped a different location, but it will always be a location that is already related to that customer. How do I create a drop down to allow the person who is creating the new Part number to pick from a list of locations for the customer that is already assigned. I can create a report link that does that, but not a drop down.