I'm still experiencing the problem in adding new detail records and having them linked to the proper master record, in a user friendly -- read that SAFE AND WITH DATA INTEGRITY -- manner.
Let me give an example:
I'm displaying a Client Record, this record has links to contacts and contracts.
I click on the link to contracts and display the open contracts with that client.
Let's just say there are 8 contracts associated with that client - they display just fine.
A new contract comes in from sales for that client, and I want to add it.
When I click "Add New" while displaying the sub-set of contracts that are associated only with that client, the client_id for the Client table is pointing to the top of the Client table.
I can enter any valid client_id and it accepts the record.
Question #1?
How can I make the added detail record link by default to the currently selected master record?
Also, I have a Users table which has demographic info about each user, in addition to their username and password. I would like to restrict access to the users table to only the logged in user list, view, and edit. I would also have an admin user who will have access to all user records and delete capability as well. In fact, the admin user should be the only user with the ability to delete entries from any table. I may want to expand the security scheme in the future to include certain managers more access. I just don't want to do that right now when I am so early in my learning of PHP/MySQL. I can do enough damage without their help!
Question #2?
How would you suggest I handle the security issue, particulary users having access to only their own record?
I have a table, called Publications that has a series if dates reflecting various critical points in the production cycle. These dates are computed based on a certain number of days preceeding the date the publication is to be delivered to the post office (called the in_home_dt). I would prefer that the user entering the information not have to calculate those milestone dates.
Question #3?
Is there a way I can get access to the record as it's added or if the in_home_dt has been changed in an edit?
I need to generate a series of production reports (online & hard copy) from this application.
Question #4?
Does anyone have any recommendations for a good report generator that will generate PHP code that could be linked to the PHPRunner menu, under a "Reports" selection? Maybe go to a sub-menu of available reports, or something like that. Any suggestions on that would be greatly appreciated.
I sure hope I haven't broached too many topics in this post. I apologize if I have. This forum has been extremely helpful to me, and PHPRunner has allowed me to create this application far faster than I would have been able to do it otherwise. I'm a total newbie to PHP/MySQL/Apache, coming from a mainframe COBOL background, and that many years ago.
Thank you,
Roy
