We require a small program/database to handle our customers information. We need to store the following information:
1. Organisation - Collecting information about the organisation ie, name, address, org code (must be alpha numeric), telephone number, fax number active/inactive flag, email address)
2. User - Collecting information of users, holding their name, telephone, position, fax, email address & org_code, access level, password)
NOTE: The password field we want a button to create a unique 8 digit alphanumeric password or allow us to enter a password specified.
3. Access level screen - allowing us to select the different access levels available.
We need to be able to select the organisation and view all users attached to the organisation, giving us the ability to make the org and/or users inactive or active.
Reporting we want to be able to email the user once they have been added to the database.
We also, would like a report that will email each nominated email address on the organisation to perform an audit of users registered with us.