Jump to content
Sign in to follow this  

Deleting a record deletes all linked records!

Recommended Posts


New to this FM7 game but enjoying it - sort of!

Can anyone help?

I have developed a job management system for my design company. It has a 'customer' table with the client details in. From this layout we then create a Job Sheet (a new table) and from there we can create Print Entries (new table) and separate Time Entries (new table) for each job.

Each Job Sheet is given a unique serial number which is then copied (using copy and paste??!!) to each new Print Job, or Time Entry and used as the relationship. It works well, except for when it comes to deleting any separate elements of a job file. For example if we delete a print entry for a job it deletes EVERY record connected with the the job number including the original Job Sheet!!!

Hope this makes sesnse and someone can help?



Share this post

Link to post
Share on other sites

Check to see if the 'delete related record...' is checked in your relationships between the two table occurences. If you do not want the related records to be deleted, you must uncheck the option.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.