Not really.

You want something like this (untested since I dont have your DB).

If someone else has a better idea, please chime in.

<object name="award" table="tblAward">
        <id name="awardid" type="numeric" />
        <property name="award" type="string" />
</object>

<object name="director" table="tblDirector">
        <id name="directorid" type="numeric" />
        <property name="name" type="string" />
        <manytomany name="Awards" table="tblEntityAward">
                <link to="director" column="fk_parent"/>
                <link to="award" column="fk_award"/>
                <collection type="array">
                        <order property="year_awarded" order="asc"/>
                </collection>
        </manytomany>
</object>

<object name="actor" table="tblActor">
        <id name="actorid" type="numeric" />
        <property name="name" type="string" />
        <manytomany name="Awards" table="tblEntityAward">
                <link to="actor" column="fk_parent"/>
                <link to="award" column="fk_award"/>
                <collection type="array">
                        <order property="year_awarded" order="asc"/>
                </collection>
        </manytomany>
</object>


On Jan 27, 2:30 pm, Jorge Loyo <[email protected]> wrote:
> Would this make sense??
>
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to