I have built a fairly simple database application that is basically a call center logging program. It is based on three tables:
- client_info (master) - includes: ID, name, address, phone, assigned to, etc. "assigned to" is a lookup that is validated against the "users" table below.
- call_detail (detail) - includes: ID, call date, who took call, notes. It is linked to "client_info" record based on foreign key ID
- users (includes: login name, password, etc. - used for security in login screen and "assigned to" field in "client_info" table)
Simple real-world example:
Call center has 2 reps:
rep1
rep2
A call comes in and rep1 answers the phone. It is client "A" on the other end.
rep1 is already logged into the system with their user ID and password found in "Users" table.
rep1 finds the "Client_Info" record for client "A" and clicks on "Call_Detail" link and clicks to add a new "call_detail" record.
2 questions:
- I'd like to have the "Call Date" in "call_detail" default to today and not be editable (either during the "Add" or via "Edit" later on). I can't seem to figure out the right sequence of settings to make this happen and still be able to see the date in the "View".
- I'd also like to have the "who took call" field in "call_detail" default to the currently logged in user. Is this possible?
Thanks so much for any guidance. PHPRunner ROCKS! It is already saving me a butt-load of time!
~Mike.