Page 1 of 1

Group E-mail

Posted: Fri Nov 10, 2006 7:31 am
by laknal
Hi,

I have to send group emails based on the category selected by user in a product request form. Currently I have emp table with associated role and email.

Do I need to add category table also?


Thanks.

Posted: Fri Nov 10, 2006 11:45 am
by John Cartwright
I don't understand, do you have the product category stored somewhere?

Group E-mail

Posted: Fri Nov 10, 2006 12:44 pm
by laknal
Hi,

I don't have category table. But the requirement is to send email notification to recipients upon product selection by user.

For example:

User can order product no:1 and 2.

Upon ordering product no:1, I have to send notification to employees in product no:1 section.

Thanks.

Posted: Fri Nov 10, 2006 12:47 pm
by Burrito
if your database is normalized, you should have a separate table that links people to their product. You can then select off of that table where the product is the one that is purchased.