Erasing Files

[Saddletramp]

I am having an issue with Layouts that I don't understand. Lets say you have just finished entering a new record with all the data in the tabs as well. You go to hit the "New Record" button and accidently hit the "Duplicat Record" button instead. So needless to say you hit the "Delete Record" button. Well, when you delete the new duplicate record it also delets the origional file and all the data in the underlying related tables as well. Why, and How do you stop it.

I can logicly explain why it would delete underlying related records but why would it jump to another record by the same ID number and delete it as well.

Thanks

The Tramp

Edited April 30, 2008 by Guest

[comment]

Could it be the same issue as here?

http://www.fmforums.com/forum/showpost.php?post/289342/

[mr_vodka]

My guess is that you have it to cascading deletes in your relationships graph; one of which leads back to deletion of the parent record.

Your issue of it deleting all the related records is all the more reason why a unique ID really should have been used to begin with.

http://www.fmforums.com/forum/showtopic.php?tid/194785

[Saddletramp]

Your issue of it deleting all the related records is all the more reason why a unique ID really should have been used to begin with.

You know it's funny, that thought crossed my mind as I was writeing the orig. post.

Anyway, this cascade switch you are referring to, is that were the check mark is for "deleting files in this table when related files are deleted in other tables"?(termonology issues again)Can you delete files from a flow down perspective but not back up again?

I am teaching myself FM with an Access background. I am used to the ability to do queries and creating relinks as needed in Access. Here it seems I am stick with the opperationl links to aquire all my reports, one of the reasons for my afore discussed link code. I am also just getting back into IT after a 4 year absence.

Thanks

The Tramp

Edited April 30, 2008 by Guest

[mr_vodka]

is that were the check mark is for "deleting files in this table when related files are deleted in other tables"?(termonology issues again)Can you delete files from a flow down perspective but not back up again?

Yes. You can check either the parent side or the child side of your relationship. The issue becomes if anywhere of all your relationships, you have it to delete the record where the child table occurence of either the child side or the parent side is for that main table and that option is turned on, it will delete.