>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?
HOw are you trying to do the copy?
You should be able to use something like:
REPLACE ChildTable.NewFK WITH ParentTable.NewPK FOR SEEK(ChildTable.OldFK, "ParentTable", "OldPK")
Erik Moore
Clientelligence