01-13-2012 12:22 PM
I would like to list the sort of equipment my clients have. I am open to any ways of doing this. Right now I have created a character field 'Equipment' associated with a drop-down list 'Equipment'. The values of the drop-down list are the sorts of equipment the client is using, for instance:
Blue Widget Stamp
Red Widget Lever
My clients have many pieces of equipment, so one company may need 15+ pieces of equipment associated with it. The problem is that when I associate so many pieces of equipment, I am suddenly over the character limit (450) for the field.
I would use a memo, but I can't find a way to introduce a new line within a memo.
01-13-2012 12:33 PM
There are at least a couple of add-ons that can be used to create subentities (for a DiY solution). It sounds to me like that is what you need to do. Or you can find a ACC to do a customization to do the same thing.
01-13-2012 12:56 PM
Having an ACC assist with customization and/or using an add-on product to create a custom equipment table are both very vaible alternatives.
Another solution, so long as the names of the pieces of equipment doesn't change often would be to come up with a naming convention for them so you can shorten the names in the multi-select combo box and as a result, be able to select more of them. This is of course depedent on the names of these items and how many there are. Or if the equipment comes in certain 'types' you could have multiple multi-select combo boxes each for a particular type of product.
01-14-2012 06:46 PM