Adam Stein wrote:
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, you're right on! Somehow there's a group of records with a 900 ID
in Table-2 but no 900 record in Table-1. Thanks, I knew it had to be
something obvious.
Dick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
