how would???

[learningman]

Im my online photo album i have three tables categories, pictures, and comments only logged in people can post or edit or leave comments. I also have a chat room that only logged on users can chat on. When you sign up for an account you add name ..password,ect,ect, and an Email address. Now here is my question, I want to have a link or button click that would say leave message..to the person that posted the pic. What table would the Email go in the pictures or the comments,or would I need a fourth table? Any help on this would be greatly appreciated. I seen a working example of this at Plenty of fish .com you click on a pic after you create an account and you will see the send message button. But you never see the persons email. I would like this but am sure i am not smart enough yet on this matter Sincerly Paul quinn

[Christian Graus]

I'd imagine that the logical thing would be that a users email address is part of the table that stores login information, and the id of the user who sent the photo would be stored in the table with the photos. So, you'd use the Id to look up the email address in the other table. This is really a SQL question.

Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )