I'm working on a simple support email system. I've set up my table as follow:
Support Table ============= SupportID Thread Message Email DateCreated DateUpdated ContactResponse
I've created a form that the customers can fill out and email to me, but my question is how would I reply back to the customer using the same table or should I create a new table to reply back to the customer?
For me webspace is precious. The more I can use for database storage the better. So if its email related I let my email handle it but using a form and cfmail is great. If you really really need to store the email messages in a database that users email you, you can create a seperate table linking to that one with your replies very easily. Every unique support question has its own ID, so now what you can do is create a table called something like tblTechAdmin, and in there it'll have its own ID called TechID and you'll store the SupportID in there as well as a Foreign Key. My main question is though why are you storing these email messages in a database?? Is it a mailing list?? Just wondering because your actual email would be much better suited for this mate.
That extra database table I mentioned you should create though is assuming that for every support question emailed to you that their will be only 1 but there will be many responses from you. If that is NOT the case then what I suggest is simply using that one table you already created and create a field called TechMessage, where you store the message in reply to the users support question. And whenever you or the user wants to send another message just append the message to the database message field. Hope you are following me on this. Any questions, let me know.
We will come... We will play... We will conquer... We are Laziales!!... Fear us.
This message was edited by JJfutbol on 3-1-05 @ 1:10 PM