Implement and showing many to many relations?

Next topic

Author	Message
Adolfo Barragán	Tuesday 25 March 2003 2:37:38 am I'm newbie in ez publish, and I don't know how to implement many to many relations. In a database model, I make the following but, how can I do in ez publish? I the conceptual model Ihave 3 classes (Countries, Packs, Species) and 3 relations: Countries--Packs (1:M); Countries--Species (M:M) and Packs--Species (M:M). In addition, the relation Countries-Species have their owns attributes and also the relation Packs-Species. So, In the physical model I have 5 classes (tables): Countries, Packs, Species, Countries_Species, Packs_Species and their relations are: Countries--Packs (1:M) Countries--Country_Species (1:M) Species--Country_Species (1:M) Packs--Pack_Species (1:M) Species--Pack_Species (1:M) When an user click on "content/view/full/Country_Id" I need show the attributes of Country_Id plus a list of Species of that country (and attributes of relation) plus a list of Packs of that country. Similary with "content/view/full/Pack_Id", I need show Pack's attributes plus a list of Pack's Species (and attributes of relation). And finally, when the user click on "content/view/full/Specie_Id I need show Specie's attributes plus a list of Packs and Countries where Specie is assigned to. I'm sorry the extension of question but I'm weeks to battle with this and I don't find a solution. Thanks in advance

Author

Message

Tuesday 25 March 2003 2:37:38 am

I'm newbie in ez publish, and I don't know how to implement many to many relations. In a database model, I make the following but, how can I do in ez publish?

I the conceptual model Ihave 3 classes (Countries, Packs, Species) and 3 relations: Countries--Packs (1:M); Countries--Species (M:M) and Packs--Species (M:M). In addition, the relation Countries-Species have their owns attributes and also the relation Packs-Species.

So, In the physical model I have 5 classes (tables): Countries, Packs, Species, Countries_Species, Packs_Species and their relations are:
Countries--Packs (1:M)
Countries--Country_Species (1:M)
Species--Country_Species (1:M)
Packs--Pack_Species (1:M)
Species--Pack_Species (1:M)

When an user click on "content/view/full/Country_Id" I need show the attributes of Country_Id plus a list of Species of that country (and attributes of relation) plus a list of Packs of that country.

Similary with "content/view/full/Pack_Id", I need show Pack's attributes plus a list of Pack's Species (and attributes of relation).

And finally, when the user click on "content/view/full/Specie_Id I need show Specie's attributes plus a list of Packs and Countries where Specie is assigned to.

I'm sorry the extension of question but I'm weeks to battle with this and I don't find a solution.

Thanks in advance