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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

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