Author: EzzBoy | Posted on: 1/21/2011 11:47:34 AM | Views : 635

I am using Asp membership controls in my project. I have aspnet_Users table that keeps users log in information. I understand that if I want to add custom fields about the user like email, phone etc, I can use asp profile which adds these additional fields to the aspnet_Profile table. 
1. Does it add the new field as an additional column in aspnet_Profile table?
2. Lets say  I add TripId as a custom field to the profile table. TripId actually comes from another table called tblTrips where it is the PK for that table. A single tripId can have multiple UserIds. How do I get this relationship work .. If I had TripId in aspnet_Users, it would be simple, but  I cannot do that.. I am adding this tripId to aspnet_Profile table.. so how can I achieve this one to many relationship between tblTrips and aspnet_Users table.
Thanks in advance for help.
...

Go to the complete details ...