Hope the detail below makes sense. Basically I'm looking for the pro's and con's of adding five Custom Item Fields (checkboxes) vs adding a custom record tied to the item master consisting of those five fields.
I want to add several "related" fields to my Item master. In simplest terms, they would be several checkboxes indicating which "outlets" (customers, websites, etc.) I want to "publish" a given inventory item to. FYI - the actual implication is to support saved searches to provide Inventory Status reports (EDI 846) to various customers (or classes of customers) as well as organizations / catalogs such as GXS.
The custom record checkboxes seem the easiest to implement, manipulate, search, display and even delete (when an "outlet is discontinued).
But, it seems in-elegant somehow to add individual check boxes for each new category (even if I name them similarly and put them in Field Groups or Custom Tabs on Forms).
I guess the next option would be to use a Multiple Select /List Items. But is seems that would be a nuisance for casual searchers to deal with and maintain.
Next thought was a custom record type (again consisting of the check boxes). They would be grouped / segregated but I'm not sure if that would be over complication. Especially since it seems (from my limited understanding) that each checkbox basically has a one-to-one relationship with the Item Master item whereas a child custom record type is more geared to a one-to-many relationship.