Fields: UserName, Password, FirstName, LastName, .........
2) UserLoginTransaction: Maintain the UserLogin Records
Fields: TransactionNumber, UserName,LoginTimje,LogoutTime,..........
3) VoiceFileTable:Maintain the voice files uploaded by Users.
Fields: Transcriptionid, TransactionNumber(Ref. UserLoginTransaction), UserName(Ref. UserMaster), VocieFileName, voiceFilePath, ........
When user uploades the file then first they needs to login. Upon login unique transaction number will be generated and the login information will be entered to the UserLogInTransction Table. When user upload the files first the last transaction number will be taken from the UserLoginTransaction and then that is going to be added to the VoiceFileTable along with the username.
So my problem is that when we move all the users to the DNN user table, how can we enter the login details to the 'UserLoginTransaction' which we needs to enter into the voiceFileTable and rest of the tables are depends on that.