I need to take a value from aspnet_profile and map it across into aspnet_users

Hi all,

I have created a website, that uses membership & roles etc.  The website displays different employers information, specific to whom is logged in. (UserID is related to EmployerID)

My plan is to have an 'admin' person create each of their associated colleagues an account.  So when a new account is created it takes the same EmployerID as the one creating it.

What I need is some sort of mechanism for the EmployerID value in aspnet_profile to be mapped accross to aspnet_users

(I will initially create each of these admin people and associate them with their own data, EmployerID)

thanks in advance for any suggestions

 
...