This is great (and the type of mapping I was hoping for). Thanks for the link and the help.
On 3/21/07, Tore Halset <[EMAIL PROTECTED]> wrote:
Hello. We call this a flattened many to many relationship. http://cayenne.apache.org/doc20/cayennemodeler-flattened- relationships.html After flattening you will be able to call city.getStates() and so on. Regards, - Tore. On Mar 21, 2007, at 16:20, Michael Lepine wrote: > Hello all. I am a fairly new user of Cayenne and am trying to get more > familiar with the API and modeler. My question deals with an > identity table. > I have not seen any documentation (or examples in the > documentation) dealing > with this issue, which is why I'm posting to the list. > > As an example, let's say I have three tables: city, state and > city_state, > where the city_state table is merely an identity table composed of > foreign > keys to the city and state tables. > > In my application, if I know the primary key for a state record, > what would > be the best way to retrieve all the city records associated with it? > > Thanks for any advice. > > - Mike
