Mode of transport to pull through from the vendor record to line level when a field is selected.. 1. how should this look on the vendor record? 2. how do I pull those values across when a drop down option is selected? Example: mode of transport - car, boat, plane each have a different lead time per supplier.. in this case 7, 10, 20 now when a purchase order for this supplier is created, Item A is coming via car and Item B is coming via plan.. so I have 2 fields at line level of the PO. field A is a dropdown when user selects mode of transport and field 2 which will be the lead time, it gets populated based on that selection.. so the leadtime should autopopulate to 7 and 20.. Hopefully this makes sense as an example.. any ideas how I can achieve this?

Make a custom record call mode of transport