To enhance user experience and data integrity within our application, we propose implementing a mechanism that provides a warning and prevents forms from opening when a linked item no longer exists in the database. This feature will ensure users are informed about missing linked items and avoid potential confusion, errors or data inconsistencies by opening the wrong item.

Example. If there is a link on the page from work, inventory transactions, etc. that references SO-1000012 and that sales order no longer exists, clicking the link will open the next sales order on the list, SO-1000013.

This can lead to data integrity issues and the user updating the wrong item/order, etc.

I would propose when the link is clicked:

1. Validate the existence of linked items before form submission.
2. Display a clear warning message if a linked item is missing.
3. Prevent the form from opening when a linked item does not exist.