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
This archive was generated by hypermail 2.0.0 : Wed Mar 21 2007 - 11:44:29 EDT