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.