Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why i cannot delete the records
Message
From
09/06/1998 00:06:38
 
 
To
08/06/1998 12:28:47
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00105004
Message ID:
00106167
Views:
28
Hello Dennis, >You said that the better way is to have Delete trigger for Idetail table. >How can i do this ? You should have a Primary key index in your invoice table and related Foreign key index in your Idetail table. Then, in your DBC designer establish permanent relation between tables (drag-n-drop primary key index over foreign key index). And, finally, right click over this permanent relation (thick line between tables) and you choose Referential integrity item. You'll get the form where you have the choice between Insert/Delete/Update triggers for each couple of related tables. In DELETE option choose Delete. After this done, you'll have a delete trigger that will delete all related records from Idetail table whenever you'll delete a record from Invoice table. >Hope you can teach me ? Hope this help, if something is unclear, feel free to ask again
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform