Many-to-Many Relations

Many-to-many database relations are potentially complex and to implement a Many-to-Many relation in WorkZone for File-Contact relations, you will need to use special relation entities, called FileContacts and RecordContacts respectively.

The FileContatcs and RecordContacts entities connect Files to Contacts and Records to Contacts respectively.

The FileContatcs and RecordContacts entities contain a pointer to the File or Record and a pointer to the Contact. Additionally, the Role of the Contact is also stored in the entity.