Robert,
Without knowing more I can only guess, however check to be sure you have not marked the foreign key in the child table as 'Primary' or 'Candidate'. You should have a single unique key in the parent table (Primary Key or PK) with a Primary index on it. In the Child table you should have 2 keys: A unique key, different for every child record, with a primary index and a foreign key which is the parent's primary key. Because there may be multiple records with this key, the index should be a regular index.

HTH
Barbara

>Hello,
>
>I have two tables (constit and gmaster) that I would like to start using integer keys on, each table already has approx. 20k records and they are already related by two key fields (recordid and constitid). What I would like to do is allow the framework to automatically generate the iid key for me. What I have done is copied there structures to new tables (nconstit and ngmaster) and added the iid field, index field and the NewID() in the default value. Then appended records from my existing tables and everything seems to work fine, until I try to copy the iid field from the parant to a field it the child table. For some reason I cannot copy the iid field to a field in the child table. Does anyone have any ideals on what I am doing wrong?