what is the "reference" syntax when the field that you want to reference is not the primary key in the referenced table?
for example *COUNTRY TABLE* 1. normal_default_web2py_id ## default primary key 2. countryAbbreviation ## these are standardized, and are a natural key 3. countryName What if I have another table and want to reference the countryAbbreviation field instead of the normal_default_web2py_id key? thanks, Alex Glaros -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

