I'm considering options for populating a linking table that will be needed to relate management personnel to the users they hire.

Edit: 25 May

I did find this link and the logic of it is sound: http://www.dotnetnuke.com/Resources/Forums/forumid/108/threadid/313898/scope/posts.aspx but this being said, a trigger in this case seems such a simple solution.  Is there no way around using them?

End of edit

Due to the volume of users managers will have, the owners of the site could not possibly be tied to creating users but will create the Manager's user accounts who will then create the users.

So as not to extend the User Accounts, which would be overkill, it was thought an option was to create a trigger that would fire when a user had the Manager role added to their profile.  I thought "Aha! ... there must be a database trigger used in DNN already.  All I need do is just read over existing code and glom the one that is close to the functionality I am thinking of."  Nein!  There are no database triggers in the Triggers folder under Programmability.

Is the idea of adding a trigger to do this bad practice?  I would think a database the size/complexity of DNN should have at least one trigger.  Seeing none, I question the wisdom of my approach.

If anyone has used a trigger before, if there's a head's up I need to know I'd appreciate it.  I'm going to pursue this approach as it would not be overwritten by DNN updates and would be far simpler than adding a user layer.