I have a situation where a user can login to a secure area of my site, the login details are provided by me (it's not a sign up thing).
What I'm trying to do is once they are logged in, allow them to add an additional contact themselves. However I'm having some problems working out how to do this in the database side of things.
I need the second contact to be associated with the currently logged in account, but also need them to be deleted separately. e.g. the main contact may wish to remove the secondary contact (if they leave the company etc.)
I was thinking something along the lines of a new table for the secondary contacts, then using a join by a second id... maybe 'groupid' in order to do this, but as I say I am struggling.
Can anyone advise on this.