Sounds like to me that an ID in table 2 equals 900 and there is no corresponding ID in table 1 that equals 900. Maybe somebody else knows for sure.
On Fri, 2009-09-18 at 19:04 +0000, Dick Hoffman wrote: > In OO Base 3.1 under XP SP3 I've defined a database with two tables and added > data to both. Table-1 has as primary key an Id-No. Table-2 records include an > ID-No (not an index or key and not unique) which I want to use to relate to > Table-1. Both are defined as 10-digit integers. When I go to TOOLS -> > RELATIONSHIPS, add Table-1 and Table-2 and try to drag the ID_NO from Table-1 > to > the ID_NO in Table-2 I get a cryptic (to me) error message saying "integrity > constraint violation - no Parent 900" and the relation is not established. > What > I'm trying to do seems to be very simple, and similar to something done in a > Base online tutorial, where a primary key in one table is used to relate to a > non-unique field in another table. Any help here would be appreciated. > Dick > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] -- Adam Stein @ Xerox Corporation Email: [email protected] Disclaimer: Any/All views expressed here have been proven to be my own. [http://www.csh.rit.edu/~adam/] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
