You have 2 Oracle tables where one has a Foreign Key reference to the other table defined. Correct? Could you give partial structures of each table and how you defined the PKs and FKs? If your PKs and FKs are properly created for the Oracle tables, you will not have RI problems regardless of how you handle the data on the VFP side.