PRB: Changing Field Settings of a Table Deletes Relationships
Article ID: 157404
Article Last Modified on 10/15/2003
APPLIES TO
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 6.0 Professional Edition
This article was previously published under Q157404
SYMPTOMS
If the field settings of a table in a database are modified, any
relationships to other tables that are based on that field are deleted.
CAUSE
When the field settings of a table are changed, the dependent indexes get
dropped and rebuilt, and when an index is dropped, relations referring to
it are dropped as well.
STATUS
This behavior is by design.
Additional query words: kbdse VFoxWin
Keywords: KB157404