Auto filled dropdown list
We have Deal property "Reseller". Reseller is a company object with specific property. And the number of Resellers constantly grows. The property has "single line text" type. So we have to fill this property manually and the same item may be written different. But we would like to have "Reseller" deal property type as dropdown list with single choise, which is being formed by different filters and updated automatically when new Reseller is added or deleted from the system. So we could see which deal are assigned to a specific reseller. How can we do this?