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
