Hi
I have an access database having details about projects.
The table includes project submission date,completion date,evaluation date,final report date and requestor etc.
I need to send a notification to the requestor one week before the completion date,evaluation date,final report date .
I need to create a form in which i can select any type of the notification(Completion,final report etc) . if i click the combo box of the notification, the subform should give the details of the projects which will be completing in next week and it should display the notification message in another subform.
I have another three tables:lkpNotificationType,notifications,lkpNotifi cationText.
lkpNotificationText table will give the notificationmessage.
I created the forms and subforms, but it is not changing according to the selection of the combo box.
I think i have problem with relationships and fields.
could you help me to tell me about relation and fields i need to send an email.
thanks