This project I'm working on is over my head as I'm no coder but trying to learn. I was wondering if you could provide code assistance.
I'm using ASPRunner 5.0 on an MS Access Database.
I have a table: Add_Edit_Employee_Into table & Transfer_Employee table
On the Transfer_Form table I have the following fields:
SSN
First_Name
Middle_Initial
Last_Name
From_Primary_Job_Title
From_Secondary_Job_Title
From_Third_Job_Title
From_Primary_Location
From_Secondary_Location
From_Third_Location
From_Primary_Department
From_Secondary_Department
From_Third_Department
To_Primary_Job_Title [color=#FF0000](Needs to update the Primary_Job_Title field in the Add_Edit_Employee_Info table)
To_Secondary_Job_Title
To_Third_Job_Title [color=#FF0000](Needs to update the Third_Job_Title field in the Add_Edit_Employee_Info table)
To_Primary_Location
To_Secondary_Location [color=#FF0000](Needs to update the Secondary_Location field in the Add_Edit_Employee_Info table)
To_Third_Location
To_Primary_Department[color=#FF0000] (Needs to update the Primary_Department field in the Add_Edit_Employee_Info table)
To_Secondary_Department
To_Third_Department [color=#FF0000] (Needs to update the Third_Department field in the Add_Edit_Employee_Info table)
On the Add_Edit_Employee_Info table I have the following fields:
SSN
First_Name
Middle_Initial
Last_Name
Primary_Job_Title
Secondary_Job_Title
Third_Job_Title
Primary_Location
Secondary_Location
Third_Location
Primary_Department
Secondary_Department
Third_Department
[color=#FF0000]I need to update the Add_Edit_EmployeeInfo with all of the data "To..." fields from the Transfer_Employee table with some "If Statements" applied to the Transfer_Employee table fields such as:
If the "To..." field is (null) or (please select) then I don't want it to update the Add_Edit_Employee_Info table
Any help would be appreciated.
