Jump to content

How to use "allow creation of records"...and "delete related records in this table"...in the left side in the edit relationship


Recommended Posts

How to use "allow creation of records"...and "delete related records in this table"...in the edit relationship.  I have attached a file, and I know how to use the "allow creation" and "Delete related records" on the right side(Invoicelineitem).  When I delete the records, I know it would delete the line items when I check "delete related records" in the invoice lineline items.

I don't know how to use the allow creation of records and delete related records on the left side(Invoice) in the edit relationship.  Thanks for your help

Regards,

KC

Untitled 2.png

TestRelationship.fmp12

Link to post
Share on other sites
23 minutes ago, Spidey said:

how to use the allow creation of records and delete related records on the left side

There are no rules for this. It all depends on your particular situation. Do you want the parent record to be deleted when user deletes one of its children? In the situation you describe - invoices and line items - the answer would be no. Do you want the user to create a child record first, and then - from the same layout - create the parent record just by filling out  some of the parent's details? Again, in the situation you describe the answer would be usually no. So the answer to your question would be: don't use them.

That's not to say they could not be used in other scenarios (for example in a one-to-one relationship).

Keep in mind that Filemaker doesn't know which side is "left" and which is "right". These sides exist only on a conceptual level.

 

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
×
×
  • Create New...

Important Information

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