ACD101 practice question 1 of 15

You have two record types: ACME_Student and ACME_Class. You need to add a many-to-many relationship between these two record types. What should you do?

Full set: 59 questions
Answer options
A: Create a new record type with data sync enabled, then add a one-to-many relationship from each record type (ACME_Student and ACME_Class) to the new mapping record type. Correct answer
B: This relationship cannot be modeled using record type relationships.
C: Add the relationship from either ACME_Student or ACME_Class, then select Many-to-Many under Relationship Type, and add the corresponding keys.
Correct Answer:
A. Create a new record type with data sync enabled, then add a one-to-many relationship from each record type (ACME_Student and ACME_Class) to the new mapping record type.
Explanation

Appian models a many-to-many (M:M) relationship using a third record type that serves as a mapping or join table. This mapping record type must have data sync enabled. You then establish two separate one-to-many (1:M) relationships: one from the ACMEStudent record type to the new mapping record type, and another from the ACMEClass record type to the same mapping record type. This structure allows Appian to correctly resolve the M:M relationship by traversing through the intermediate mapping record.

Why Incorrect

B. This is incorrect because Appian fully supports modeling many-to-many relationships using the standard database practice of a join table, represented as a third record type.
C. This is incorrect because the record type relationship configuration does not offer a direct "Many-to-Many" relationship type. This must be constructed using a mapping record type and two one-to-many relationships.

References

1. Appian Documentation, Record Type Relationships: In the section "Many-to-many relationships," the documentation explicitly states: "To create a many-to-many relationship, you'll create a third record type to join the two record types. This new record type will serve as your mapping record type." It then outlines the procedure, which involves creating two one-to-many relationships from the base record types to the new mapping record type. (docs.appian.com, Appian 23.4, Record Type Relationships)

Scroll to Top