use "reference table" instead of db.table as field type.
On Jun 8, 8:03 pm, Keith <[email protected]> wrote:
> Greetings:
>
> I have a company table and an address table. A company should only see
> the addresses of people associated with that company, so I reference
> company.id in the address table. Each company also has its own address
> stored in the address table, so I reference the address.id field in
> the company table. Clearly, this won't work if a table "can only
> reference tables previously defined." How do I get around this?
>
> Also, I have a student table, with two parent fields, for a total of
> three different references to address.id in the student table. How do
> I differentiate this three references in the table definition. I
> currently have SQLField('address.id') 3 times, which, obviously, won't
> work. Again, any suggestions?
>
> TIA
>
> Keith
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
