Click to See Complete Forum and Search --> : database design


solomon_13000
10-05-2006, 09:49 AM
tblUserRegistration
----------------------

Registration_ID
Email
Username
Password
Country
PostalCode
Gender
DOB


tblEmail
---------
Fields
Email_ID
Name
Description


I am having a problem with the table tblEmail. Now lets say I wish to communicate with a member in a match making site, I would have to click on a link and it will take me to a page where I can type the msg, click the send button and the message will be added on the table tblEmail. Now the problem is how will I be able to identify the mails which I have received from other members. How will I know which member send me the mail.


Your help is kindly appreciated.

chazzy
10-05-2006, 12:49 PM
you need to add 2 new fields - fromMember and toMember.