I am trying to find an OOTB method to use to accomplish this task.
I have a lookup field (Vendor #) that needs to pick up the matching values whenever a Vendor is selected from its dropdown lookup.
For example, I select a vendor (Pizza Hut) and the Vendor # field should only give me the Vendor numbers or number associated with that Vendor.
I tried a Cascading Dropdown jquery that I found through Mark Rackley, and functionally it worked, but my list of Vendors and Vendor # is about 4800 and I would have to create the relationship in the background for each and every one.
Is there an easier way to do this OOTB that wouldn’t create so much time.