Which tables do 'from' and 'to' refer to when defining a relationship? If I want to relate TableA to TableB via TableA.pkValue and TableB.value, would my objects block look like this?

<object name="TableA">
    <hasOne name="TableB">
        <!-- Relate TableA's 'pkValue' column to TableB's 'value' column -->
        <relate from="pkValue" to="value" />
    </hasOne>
</object>
<object name="TableB">
    <hasOne name="TableA">
        <!-- Relate TableB's 'value' column to TableA's 'pkValue' column -->
        <relate from="value" to="pkValue" />
    </hasOne>
</object>

Or would it be the opposite? I ask because 'relate' is a child of 'hasOne' so I'm not sure which parent from and to are more closely tied to.

--
Quidquid latine dictum sit, altum sonatur.
- Whatever is said in Latin sounds profound. -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/

Reply via email to