Author: bbcompent1 | Posted on: 11/13/2009 8:39:22 AM | Views : 416

I am using the aspnet membership and roles to manage security for my web application. What I'm wondering is how can I tie these three tables together so that when I have a user log onto their specific homepage, it will look up information on the tables egw_addressbook and ewise_device. Would I be best to create a column aspnet_id on the egw_addressbook and ewise_device or to create a table to tie these vars together, what would be the best way? I can't do anything to the my_aspnet_users table because if I alter that table the schema blows up and I get a nasty error that won't allow users to register.

egw_addressbook
         -contact_id

ewise_device
         -device_id
         -contact_id

my_aspnet_users
          -id 
A ...

Go to the complete details ...