Modeling Question
Modeling Question
- Subject: Modeling Question
- From: Jevon Hills <email@hidden>
- Date: Tue, 20 Jan 2004 11:13:28 -0700
I'm having and issue creating the EOModel I need for an application. I
believe that what I'm after can be solved with in the EOModel, but I
could be wrong. I'll explain my business need and then database model.
Database Tables:
Venue<-->>InstallHistory<<--Console<-->>ConsoleCollection<<--
>Collection<-->>CollectionContents<<-->Content
Esentially we have Venues. each venue can have 0 or more InstallHistory
items. Each install history will have a console. Each console will be
associated with one or more collections of content.
Business requirements
The application is a read-only application for viewing a current info
in our database. I started with a D2W app and customized where I
needed.
I need to select an install from a venue and view a list of its
contents.
My interface has a list of venues. Selecting a venue give a list of
installs. From here I want to retrieve a list of contents for the
install I select. I tried a flattened relationship from
console--->contents through the data model which mostly works. However
this relationship does not retrieve using InstallHistoryID in the sql
only consoleID, and a Console could be in more than one InstallHistory.
Currently if the Console is in 2 installHistory Records my content
recordset is doubled.
Is there a way to attach a condition to this relationship where venue =
selectedvenue?? Am i missing something?
tia
ttfn
Jevon K. Hills
Developer - Zymeta Media Promotions
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.