Forums / Setup & design / Related Objects with relationship attributes

Related Objects with relationship attributes

Previous topic

Setup & design

Next topic

Author	Message
paul bolger	Sunday 01 April 2007 4:26:20 pm In a site I am developing we have a database of organisations, and a database of contacts which are associated with the organisations with the eZpublish object relations system. Some of the contacts are related to several organisations, but they may have different roles (manager, for instance) with each organisation. I'm trying to come up with a way to handle this which doesn't involve duplicating the contact for each organisation they represent. Something like assigning the role as an attribute of the object relationship would do the trick, but I have no idea how you would implement this. Would some sort of Custom Tag work for this? Does anyone have any brilliant ideas? Paul Bolger Alice Springs Town Council Paul Bolger
paul bolger	Sunday 01 April 2007 11:39:56 pm Problem solved, but I'm still interested in others' opinions on whether I'm taking the right approach. I've decided to add a 'contacts' XML field to the organisations content class and add the contacts as a bulleted list of embedded objects which means I can add titles inline with the objects. Paul Bolger

Author

Message

paul bolger

Sunday 01 April 2007 4:26:20 pm

In a site I am developing we have a database of organisations, and a database of contacts which are associated with the organisations with the eZpublish object relations system. Some of the contacts are related to several organisations, but they may have different roles (manager, for instance) with each organisation.

I'm trying to come up with a way to handle this which doesn't involve duplicating the contact for each organisation they represent. Something like assigning the role as an attribute of the object relationship would do the trick, but I have no idea how you would implement this.

Would some sort of Custom Tag work for this?

Does anyone have any brilliant ideas?

Paul Bolger
Alice Springs Town Council

Paul Bolger

paul bolger

Sunday 01 April 2007 11:39:56 pm

Problem solved, but I'm still interested in others' opinions on whether I'm taking the right approach. I've decided to add a 'contacts' XML field to the organisations content class and add the contacts as a bulleted list of embedded objects which means I can add titles inline with the objects.

Paul Bolger