Virtual Foreign Key via codegen_settings.xml

Hi,

I have set up a virtual foreign key via codegen_settings.xml like this:

            <relationships><![CDATA[
            cart_order_details.order_id => cart_orders.id
            transaction.order_id =>cart_orders.id
            ]]></relationships>

The classes are created, but how can I access the related class objects like the following?

<?php
$objTransaction = Transaction::Load(1);
echo $objTransaction->CartOrders->CustomerFirstName;
die();
?>

This doesn't work, but if I define my foreign key as an SQL statement using InnoDB, that code works just fine.  Am I not able to access data like this if I use a Virtual Foreign Key?

This is the first time I've used Virtual Foreign Key's so if anyone has info on this or has used this before and can help me, I would appreciate it.

Thanks much,
Chris

I just tried using virtual foreign keys for the first time today (trying to split up tables between two database instead of one) and I am wondering if there is a trick to getting the virtual keys to generate linking objects like they do when you define foreign keys between tables in a single database?

In other words, if I have table 'form' that has a foreign key to 'user' table (both in the same database with foreign keys defined in the database), I can access the user object from a form object ($objForm->User); so I get a User object generated within the Form data class for me.  However if I split the two tables between databases and use virtual foreign keys within the codegen_settings.xml file all I get is a UserId property generated in the Form data class and not a reference to the User node.

Can the codegen generate the User objects/nodes in my Form data class using virtual foreign keys or is that not coded into the functionality?

many thanks