An administrator can create custom relationships between Forms and Fields. BLDR is flexible enough to create One-to-One, One-to-Many, Many-to-One, and Many-Many relationships between the forms.
One-to-One
In One-to-One type, the records in module 1 and module 2 are related uniquely. A field gets created in both the modules to represent the related record, i.e., a field representing the related record of module 2 gets created in module 1 and vice versa.
Example, if you want to have one organization per contact, then you can create a one-to-one relationship between contacts and organizations.
One-to-Many
In One-to-Many type, you can relate a record of module 1 (M1) to module 2 (M2) and relate multiple records of M2 to M1. A field gets created in M2 to represent a record of M1. A tab gets created in M1 to which lists the related records of M2 .
For instance, think of M1 as Projects, and M2 as RFI's. A Project can have many RFI's, but a RFI can only be related to one Project.
Projects example, a field that represents a related Project is created in a RFI record and a related tab listing the related RFI's is created within the Projects.
Many-to-One
In Many-to-One type, you can relate multiple records of module 1 (M1) to module 2 (M2) and a single record of M2 to M1. Many-to-One is a reverse process of One-to-Many. A tab gets created in M1 that lists the related records of M2, and a field gets created in M2 that represents the related record of M1.
Example, you can relate many receipt notes to a purchase order.
Many-to-Many
In Many-to-Many type, you can relate multiple records of module 1 (M1) to module 2 (M2) and vice versa. A tab gets created in both the modules to list the related records of another module. Example, you can relate many assets to a quote, and many quotes can be related to an asset.
Parent-child relationship between two modules
The field values displayed for a lookup field always depend on the values of the parent field.
Adding a Relationships
Follow the below steps to add a relationship.