>>>
>>>>1. Can it be done in VFP and is it reliable/stable
>>>yes, it's wrapped in a transaction
>>>
>>>>2. If 1. is Yes, where do you start? I want to build a rule for an update of one of the parent fields, as a test and see how it works.
>>>
>>>modi database
>>>rightclick - Edit referential integrity
>>
>>Hi Gregory,
>>
>>Sorry to trouble you with this again. I just got to try your suggestion of creating a referential integrity. But I don't seem to see this feature. Here is what I do:
>>
>>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?
>>
>>Thank you.
>
>You have to right click in the grey area or on a relationship (line)
>Also possible is in the menu: Database ...Edit referential integrity
>
>ps: the database has to be opened exclusively if you want to edit the referential integrity
I do right click in the grey area. But I don't have any relationship lines. Maybe this is what I am missing. So I need to learn how to create these relationship lines. Thank you.
Do you think that maybe I am better off using RI Builder (I think it is part of VFP9, not sure though)?
"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