|
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
|