Companies in the company table can apply for one or more applications, therefore I defined the combination table companyapplication. The company table contains records like:
1 Butson Consultancy 2 Dreamwall 3 Preston Counselors The application table contains records like: 1 Supplier 2 Consultants 3 Counselors The companyapplication table contains records like: 1 2 2 1 2 2 3 3 I can insert companies without problems, however, when I want to insert an application, e.g. Supplier I get the error mentioned above. I hope I provided you with sufficient information. Annet. -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en

