I having a go at a database for 2 departments to use within our company. 1st is SALES, the 2nd is Production. I need a system that once the sales person has entered his information it then alerts production that a quote is needed. Is there any way of doing this? - At the moment I am using a list view with check boxes against the jobs that need quotes. The only problem with this is that your are relying on the production department to check if any qoutes are needed, rather than the system alerting them to the job.

Any help would be much appreciated!

Regards,

Paul Lyward.

Use the e-mail capability of FMP to provide notification. This can also be integrated with alphanumeric pagers to provide almost immediate notification.

I am actually trying to do the same thing. I am new to databases, so take my advice for what it's worth. I am planning on making a submission form layout for sales, when a sales rep fills it out, he sits a "submit" button. This button then sends an e-mail to the appropriate people letting them know that they need to approve that record. I haven't tried it yet, though. Good luck.