Single-Line Set Type (Multiple Use, Multiple-Value Attribute) 

Definition

The set type shown below consists of single-value attributes with the attribute types checkbox, amount, unit of measure, language, currency, string, time, and decimal number, as well as the multi-value attribute with the attribute type date. The following settings were made in set type maintenance:

·        The flag Multiple Use is set

·        The flag Field Is Key is not set

·        The flag Multiple Value is set

Example

 

·        Color

·        Initial registration

·        Gull-wing doors (yes/no)

·        Total weight

·        Date of manufacture

·        Number of gears

·        Accessories

Most of this information can be described using single-value attributes because only one value is possible each time. However, it is also possible to have a variety of accessories at the same time (such as a leather steering wheel and airbags). This information can be shown by using a multi-value attribute. You define the following attributes:

 

 

	Attribute	Attribute Type	Single-Value / Multiple-Value
Color	COLOR	String	Single-value
Initial registration	INITREG	Date	Single-value
Gull-wing doors (yes/no)	DOORS	Selection field	Single-value
Total weight	WEIGHT	Quantity	Single-value
Date of manufacture	MANUFACTURE	Date	Single-value
Number of gears	NUMBERGEARS	Integer	Single-value
Accessories	ACCESSORIES	String	Multi-value

 

The set type then has the following appearance: