>Dmitry,
>
>>Open Database MyDatabase
>>Set database to MyDatabase
>>Modify Database
>>-. This opens all tables of in the database in the Database Designer window.
>>Then I try to Right click but the menu does not have an item Edit Referential Integrity.
>>
>>Could you please point me to what I am missing?
>
>vfp RI was wordy at least, not errorfree in the wizard interface in earlier versions (dunno about vfp9).
>Most people went with other tools. One of the cleanest implementations
>(done totally via SQL - think portability!!) is in the Booth/Sawyer book.
>Sawyer enhanced it even further and put it on his site - google for it or ask Naomi.
>I remember discussing some fine points in that code with her.
>
>Another solid one is Markus Winhard's AMRI.
>Or check out Rick Schummer's site: He either has a RI tool or will point you to one.
>
>regards
>
>thomas
Thank you, Thomas. I am debating with myself now if the entire process of building VFP RI is worth the effort. Since I am rapidly moving away from VFP database to SQL database (where creating RI is much simpler) I may be better off leaving the way my application works now and concentrate of other tasks. But I may look at the suggestions you provided.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham