Skip to Content
0
Former Member
Apr 21, 2009 at 09:04 AM

Consistent maintainance of data

26 Views

Hi Experts,

I need to maintain the list of recipients who need to receive a mail when a particular event occured by a particular user.

As of now am maintaining through a ztable with fields: user_id, event, mail_id.

But the user ids & the events will keep on increasing. So the data maintainance becoming complex.

Can some one suggest any standard solution, to maintain the above consistently.

Example: *user id      event          mail id*               
               user_1      event_1        mail1
               user_1      event_1        mail2
               user_2      event_1        mail3
               user_3      event_2        mail4

Thank you.