I need a database creating and integrating into some pages that I have designed.
The database contains 2 types of information.
1. Contacts
2. Opportunities
I have created pages that allow a new contact and new opportunity to be added to the database (these are attached).
There are also 2 pages,
1. List of all contacts
2. List of all opportunities
(Contacts are listed in the "address book")
So all the contacts are listed on the address-book page.
You will notice on this page some arrows, this allows for the columns to be sorted. There is also a filter drop down which allows the visitor to filter by type.
The list-opportunities page works in a similar way. Please note the "venue" column will not show the whole entry only the first 15 characters followed by "..."
Opportunities and contacts can also be edited. The editing page will look exactly like the "add" pages for both.
You will notice lots of drop down boxes on both forms. From time to time I may need to edit the options so it should be just a case of editing the options on the pages is all I need to do.
I need visitors to have to log in first. These logins can be maintained in a table in the database. No action can be undertaken unless a user is logged in.
When a new contact or opportunity is created then the user that has created it must be logged.