Populate dropdown with records from a related module

You can populate a dropdown from a query as I did, or create a relationship between country and the modules that use them asAndré Lopes suggested in the same post:

https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/2019/create-dropdown-from-module-records/7425#7425

I am curious about what you are trying to build, maintaining Zip Codes per state sounds like a bit a nightmare... are you importing individual ones from the postal service or just ranges?

FrancescaS

You can populate a dropdown from a query as I did, or create a relationship between country and the modules that use them asAndré Lopes suggested in the same post:

https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/2019/create-dropdown-from-module-records/7425#7425

I am curious about what you are trying to build, maintaining Zip Codes per state sounds like a bit a nightmare... are you importing individual ones from the postal service or just ranges?

FrancescaS

I'm guessing Andre is using on premes and can access the directories. I'm using on demand and can only use Studio.

We use these to store and calculate insurance premiums. until now we've had a rate that applies to the whole state, but we're currently negotiating with a new carrier and they're suggesting lower rates for some ZIP codes. I'm trying to see how practical it'll be.