Question regarding designing a status report (1 Viewer)

[jhahes]

Can someone please help me with a couple of ideas in designing a status report.

I am trying to design a status report for a loan applicant.

The main table will have a unique key of a loan number


There are about 15 steps during the process, i only need 2 pieces of information each step.

1. has it been done (possibly a check box)
2. Date it was completed

the only complex issue is that i would like to send an email to all parties involved (5) in the transaction


thanks for any help

Josh

 

[OllyK]

Can someone please help me with a couple of ideas in designing a status report.

I am trying to design a status report for a loan applicant.

The main table will have a unique key of a loan number


There are about 15 steps during the process, i only need 2 pieces of information each step.

1. has it been done (possibly a check box)
2. Date it was completed

the only complex issue is that i would like to send an email to all parties involved (5) in the transaction


thanks for any help

Josh

I suppose the first questions are:
1) Is this a multi user app with the UI and tables separated?
2) Are you looking to plug in to a server mail solution such as exchange, write your own mail sender (not actually that hard) or use a client app?