Many to Many relationship implementation

Please follow the documentation for building up Many-to-Many Relationships.
Some points to remember is :
1. Proper mapping of relationships is being done. (Primary and Foreign Key).
2. Have well defined primary key column instead of allowing allowing appian to create some random primary key column.
3. Also considerations need to taken in case of update and deletion of data. (CASCADE or RESTRICT).
4. Incase you are writing to all the tables, i will suggest using of a nested CDT to write data instead of many write to datastore entity nodes. So, it would make less database calls and will be more efficient.

I hope these points help you for your implementation.

Please follow the documentation for building up Many-to-Many Relationships.
Some points to remember is :
1. Proper mapping of relationships is being done. (Primary and Foreign Key).
2. Have well defined primary key column instead of allowing allowing appian to create some random primary key column.
3. Also considerations need to taken in case of update and deletion of data. (CASCADE or RESTRICT).
4. Incase you are writing to all the tables, i will suggest using of a nested CDT to write data instead of many write to datastore entity nodes. So, it would make less database calls and will be more efficient.

I hope these points help you for your implementation.