Express objects creation/setup

Permalink
Hello,

I got asked by a client to renew his website in Concrete5, while settings it up a ran into a problem that seems impossible to pass.

I have set 3 express objects:

- Projects
- Roles
- Persons

Projects has associations "One to many" with work roles and persons, Roles has "Many to Many" with Persons and Projects, Persons has "One to many" with Projects and Roles

- One or more persons can work in one projects (at times with more than one role)
- One or more roles can be given to a Project

What i am trying to do is:

put person X in project Y with role Z

Examples:

Assign Jane Doe to Project 1 as Director
Assign John Doe to Project 2 as Designer
Assign John Doe to Project 1 as Designer and Editor

Project pages needs to be configurable only in composer with simple dropdowns and checkboxes by linking the created project, roles and persons in the backend (which i will develop when i manage to figure this out)

Is my logic flawed or it's impossible to do it all by adding everything just in the Project Objects?

Thanks in advance for the help

View Replies: