I have a Microsoft Access MDB database, which I need an ASP back-end built for.
I have tables which list quotes, clients, users (clients, managers and staff), events (groups of shifts), shifts, and skills. There are linking tables which associate quotes with clients, quotes with events, events with shifts, shifts will skill requirements, staff with skill levels, client user accounts with clients, etc.
I need simple forms (no DHTML / CSS / AJAX or other complicated script) which will allow adding and editing information in each of these tables whilst maintaining referential integrity. I need to have a dashboard where I can view a calendar which shows events (and shifts) that are quoted, confirmed, completed and invoiced, and the staff assigned to them, or the empty shifts and their skill requirements. I need to be able to access all of the linked information quickly - ie clicking a rostered staff member accesses their profile, clicking an event takes me to the quote.
The MDB is attached with a minimal dataset. I can provide further example dataset if required.
Language must be ASP. I am able to code this in ASP but do not have time, and need to be able to customise it further if required on completion.
Good code format and commenting is essential.