Mikesdotnett... thanks for the info.  Please look at this, THIS is the what i have so far.  I think i need help in area #2 below.  Thanks again.

*****************************************

 // 1. Insert new member data into Account table 
     var db = Database.Open("AutosDB");
            db.Execute("INSERT INTO AccountInfo (Created, FirstName, lastName, Phone, Email) VALUES (@0, @1, @2, @3, @4)", Account_DateTime, Account_FirstName, Account_LastName, Account_Phone, Account_Email);
 
    // 2. Get the new member ID that was JUST created from Account table (i know this is wrong, what must i do???... so, How do i get the last ID that was just creatd?)
    var selectQueryString = "SELECT * FROM AccountInfo ORDER BY memID Desc maxrows=1";
 
    // 3. Insert new member ID into Profile table
    db.Execute("INSERT INTO ProfileInfo (Created, memID) VALUES (@0, @1)", Profile_DateTime, memID);

*****************************************

Thanks Mikesdotnett...  "WebSecurity helper" that was my next step... i thought i would do this first before getting into more stuff i had not done before (i know i will have to incorporate the asp.net WebSecurity helper with my member sign up).