>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