You can use associations to create relationships between two different forms and add qualifications. The following topics are provided:
Direct associations are primary key and foreign key associations between two forms. The multiple fields from primary form can be used as a primary key and similarly, multiple fields from secondary form can be used as a foreign key. In other words, each field in the primary key maps to a field in the foreign key and is called direct association. The fields used for the primary key may or may not be uniquely indexed. In BMC Remedy Developer Studio, you can create two types of direct associations: one-to-one association and one-to-many association.
You can use two different forms for creating direct associations in BMC Remedy Developer Studio: primary form and secondary form. You can also enforce associations between these two forms. For information about how association enforcement works, see Associations enforcements.
Direct associations are helpful when you can establish a primary key — foreign key associations between fields of two forms that you want to associate.
- A direct association is a direct relationship between two forms.
- This association is used wherever there is parent-child kind of relationship, such as purchase order to purchase order line item.
- This association supports one-to-one and one-to-many relationships.
- Multiple fields from the primary form can be the primary keys and similarly multiple fields (the number of fields in the secondary form should be same as primary form) from the secondary form can be foreign key. Each field of the primary key maps to a field in the foreign key. This association is also referred to as PKFK mapping.
- The fields used for the primary key must be uniquely indexed for best results.
Indirect associations are the associations created using an association form apart from primary and secondary forms. This form stores the foreign key for both the primary and secondary forms. Multiple fields from the primary form can be mapped to the same number of fields on the association form and similarly multiple fields from the secondary form can be mapped to same number of fields on association form. In BMC Remedy Developer Studio, you can create three types of indirect associations: one-to-one association, one-to-many association, and many-to-many association.
You can create indirect associations in BMC Remedy Developer Studio with the help of an association form, along with the primary form and secondary form. You can also enforce associations between these forms. For information about how association enforcement works, see Associations enforcements.
- This type of association supports one-to-one, one-to-many, and many-to-many relationships
- This association is used for describing peer relationship or loose relationship such as a relationship between incident management and change management.
- Records in the two forms are related to each other by creating a record into a third form called association form.
- Association form holds the foreign key for both primary and secondary form.
- Multiple fields from the primary form can be mapped to the same number of fields on an association form and multiple fields from the secondary form can be mapped to the same number of fields on the association form.