Mariano is probably right that you want to avoid circular references if possible. But the example you provided doesn't look like a circular reference to me.
What you might want to do is define the tables first without the reference, have Web2py create them and then add the reference after the tables are created and have Web2py migrate the alterations.
