General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Do you have a primary key index on each table and foreign key indexes in related child tables with a permanent relation set from parent to child?
>i have the dbc ope exclusivly, did clean up database, did validate datbase recover cleaned up again and still no potatoes...
>
>
>>You must have the database open exclusively and you need to have a freshly cleaned up the database before the RI builder will run. I thought it would still be avaiable on the menu (not greyed out) but would pop up a message box indicating what was wrong though.
>>
>>>I did a validate data recover and still no ref integrity
>>>
>>>
>>>>Both of tables must have indexes. One of them tables must have a Primary index. Get the index name from table window and drag it to second table index name thus You build a relation. Duoble Click on Relation & You get "Edit relationship" window. On it there is a Referencial Integrity Button.
>>>>
>>>>>>Put some tables in DBC,
>>>>>
>>>>>Just did
>>>>>
>>>>> Create relations between them
>>>>>
>>>>>Thats what does not work!!!!!!!!!!!!!
>>>>>
>>>>>& make sure if You are opened the DBC exclusive
>>>>>
>>>>>It is
>>>>>
>>>>>
>>>>>PS I can clean up the database since it is open exclusively
>>>>>PS vfp8sp1, xpsp2
>>>>>
>>>>>
>>>>>>
>>>>>>>I am creating a new dbc (first time in years!, and once over 60 one forgets everything)
>>>>>>>the referential integrity builder is greyed out. I don't remember what to do to be able to create ref. Integrity
>>>>>>>
>>>>>>>Thanks
>>>>>>>
>>>>>>>Peter
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only