Hi, i am currently implementing a complaints and suggestion system for an estate agency using asp and access. I have 4 entities currently, employee, customer, notification and an action list. A customer submits a notification and an employee acknowledges and manages them.
An employee needs to be able to select from a drop down box in a browser a standard reply letter to contact the customer. The customers address details should be displayed at the top of the letter.
How do i go about accessing the standard letters, do i store them in the employee table in my database? and also, how do i access ms word through my browser and retrieve and display the customers name and address at the top of the standard letter? Im confused