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]
