Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record moves with the table relation?
Message
From
29/05/1998 10:11:28
 
 
To
29/05/1998 10:06:30
Tan Gay Cheong
Cybercomp Computer Services
Singapore, Singapore
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00103076
Message ID:
00103080
Views:
29
>I have a questions, does the child table's pointer the same as the parent?
>
>If i delete a record on the parent table, will the child table goes the same record number as the parent do?
>
>Or should i set triggers to do so?
>
>I am trying to move the tables together in a form, but don't seem to be getting the right way. Can anyone explain to me how to make the tables work in the form?
>
>I have set three tables in the datasession of the form, what can i do from here?

Child table has own pointer which moves in accordance with parent table pointer if you set temporary relationships (which IMO is bad practice). When you delete a record in parent table, child records still exists and, because deletion itself doesn't move pointer yet, then child pointer is on the same place. If you want to delete child record(s) too, then you could implement RI Delete Cascade Trigger.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform