>
>There must be relationships established ( when you create table .... foreign key)
>If no relationships are established, you can add them in Modify database
>
>Click on a PK from a table and drag that to a FK of the related child table - then you will see the (new) relationship (line)
>
>When you have all your relationships, then do the right click - Edit referential integrity
>When you are done with that it will ask whether you want the code generated
One important tip before editing Referential Integrity (at least it was important in VFP9 SP1):
PACK DATABASE myDB
COMPILE Database MyDB
(backup also will be good)
and then you can use it. Otherwise there is a potential for Internal Consistency Error.
If it's not broken, fix it until it is.
My Blog