When to choose the option "Delete row upon link deletion" in Timetonic, a new sub-option has appeared in the link column configuration window. It appears to you when you select the Unique Creation option. By selecting it, you will ensure the deletion of rows in the attached table in case of deletion of these links in your link column, to avoid orphan rows. When to activate this sub-option Delete line upon deletion of link. Here are two examples where it will be particularly useful to validate it. In an Inventory Session table, you generate rows in the link column that correspond to produced reference rows. If, however, you made a mistake and want to delete one of these product lines, you can be sure that this product line will also be deleted in the table it is attached to, to avoid this line becoming orphaned. Another example is the creation of quotes. When inserting sold service lines into your quote, you want to delete or correct a line from the link column, delete it, and ensure that in the table it is attached to, this line does not become orphaned and will also be removed. Let's concretely look at how this is represented. I am in a quote table. I will open the display of this quote and go to the line of the link column that allows me to insert the billed products in this quote. For example, I will delete the first line, line 136. I get a message asking me if I'm sure want to delete the link. I delete the link. Let's look at the attached product line table, the product, and how it's represented. I look for the 136 product line and see that it is no longer linked to our quote, so it is an orphan line. In this case, if it was a mistake, I could attach it to its quote. If not, I select it and also delete the line. The line is deleted. Now, let's look at activating the option to delete the row at the deletion of the link to see that we will no longer need to do these actions. Let's go back to the quote table and open the link column configuration window. I will now activate delete lines at link deletion, which is of course only a sub-option of unique creation. If I don't tick unique creation, I don't have access to this sub-option. I tick unique creation and I tick deletion of the row at link deletion and I validate. Let's reproduce one more time now, with the activation of the option, a product line in a quote. I will delete line 137. It validates, I close the quote, and I go back to my product lines. Line 137 is no longer in my table. To confirm, let's go to the trash to see that it was indeed deleted at the time of link deletion in the link column. In conclusion, activating this option guarantees an end-to-end deletion and a clear representation of your data rows in your spaces. Test it as soon as possible in Timetonic.
