Secure Relations

Ask for Help
1

Hi,

I always use Row IDs for my Relations and have noticed that there seems to be no built in way to avoid that the User deletes a Master Row and therefore leaving Child Rows as orphans, here is a simple example:

Company Table:

Companies

Contacts Table:

Contacts

Company Row ID ties the Contact to the Company Row ID.

When deleting the Company the Contact become orphan and there is now way to know which Company he belongs to.

I tried to prevent this with Actions but to no avail.

Some help would be highly appreciated since this is not a correct behaviour at all.

Mike

2

Create a multiple relation in your Companies table that matches all rows with the same Company RowID in your Contacts table, then only allow a Company to be deleted when that relation is empty.

1 Like
3

Darren_Murphy Many Thanks for the quick relay, Easy Peasy :slight_smile:

ACTION

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.