Hi everyone,
I need a way to be able to add a lot of custom fields for different types of Accounts. These fields are not for every type of Account, so I don't want to end up with 100 custom fields in the standard Account entity where 15 fields are only 12% populated, 20 different fields are only 10% populated, another 12 fields are only 20% populated and so on. I would like to put each group of custom fields in their own custom entity and when a drop down, say Customer Type is chosen, then populate a section of the screen from the corresponding custom entity. So say I choose Customer Type "Manufacturer" then the 15 custom fields from the custom entity AcctManfacturer fill that screen section. Is there a tool available somewhere that would assist with writing code for something like this?
Thanks in advance for any help or guidance you can provide.