Antonio ---
I see the problem. You are confusing the difference between setting a DataEnvironment Relation in a Form, and setting Referential Integrity relations in a database container. Referential Integrity, in the DBC, is nothing more that code generated to control what happens to child tables when the parent table has an INSERT, UPDATE, or DELETE. It does
not control the record pointer.
Try this (sometime after the tables are open)...set the proper relational index in the categoria table (SET ORDER TO {tagname}). Then:
SELECT associado
SET RELA TO nrcateg INTO categoria
Everything should work fine.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05