My issue has only developed as a result of a new person using my existing database program. My other employees understand how the Add/Edit function works, but this person did not; even after having explained the process. I can't seem to find a way to resolve the issue on my own, hence this new thread.
The attached (form_Main_Project.jpg) is the main record form whose information can't be edited. (NOTE: The JT ID# in the top right corner (in this case 78021) is the Primary Key#). In order to allow employees to either edit the existing information or ADD a new record, the employee clicks on the "Add/Edit Job" button in right corner of this form, which causes the (form_Add-edit-1.jpg) to open. At this point, the employee can edit anything in the record with the exception of the JT ID#.
If the employee doesn't want to edit the existing record but only wants to ADD a NEW record, they simply click on the "Add New Job" button and a new record appears, as shown in (form_Add_record.jpg). Once any information is added into the Job Name field, a new JT ID# is automatically added. Employee can add info into the balance of the fields and then close the form to save the new record.
In a perfect world, I would just want my employee to have two separate buttons on the (form_Main_project) one to "Add New Record"
from the (form_Main_project) which would only allow the addition of a new record. I've tried to do that, and once I click on Add New Record it opens up a blank (form_Main_Project) but I can't edit the form because I have locked down all the fields.
I hope this isn't too confusing, but I'm not sure where to go from here. Any help would be greatly appreciated.
Mark
The attached (form_Main_Project.jpg) is the main record form whose information can't be edited. (NOTE: The JT ID# in the top right corner (in this case 78021) is the Primary Key#). In order to allow employees to either edit the existing information or ADD a new record, the employee clicks on the "Add/Edit Job" button in right corner of this form, which causes the (form_Add-edit-1.jpg) to open. At this point, the employee can edit anything in the record with the exception of the JT ID#.
If the employee doesn't want to edit the existing record but only wants to ADD a NEW record, they simply click on the "Add New Job" button and a new record appears, as shown in (form_Add_record.jpg). Once any information is added into the Job Name field, a new JT ID# is automatically added. Employee can add info into the balance of the fields and then close the form to save the new record.
In a perfect world, I would just want my employee to have two separate buttons on the (form_Main_project) one to "Add New Record"
from the (form_Main_project) which would only allow the addition of a new record. I've tried to do that, and once I click on Add New Record it opens up a blank (form_Main_Project) but I can't edit the form because I have locked down all the fields.
I hope this isn't too confusing, but I'm not sure where to go from here. Any help would be greatly appreciated.
Mark