I am starting to believe I am attempting the impossible here, but here goes. I have the following tables:
Here is the scenario that I am trying to accomplish. The Job table tracking projects in house. I would like a "time-line" of activity for each job. I have created the Job_Dates table to house all of the different dates associated with an given project (received, started, in progress, completed...) I also need to assign an employee to the project.
The database solution currently in house has an "Rapid Input" screen which facilitates the entering of many job/date combinations for a given date type (Verified, Completed, Reported, etc.). I have a layout with a portal to allow the rapid input of the dates by category.
My issue is portal of entering the Due Dates and assigning the employee. I understand that the tables are not related and need to set up a script to "transfer" the employee input to the Job table. What I am trying to accomplish is a conditional value list showing the active employees, and using that to trigger a script to update the Job table with the selected employee. In order to make the "Rapid Input" layout to function correctly, I have the following TO's:
to feed the layout:
So where I stand now is the tabs activate a script to change the value of DateType (the date type in the header is there for debugging), I can enter the JobID, and the date and date type function properly but the drop down list for active employee does not. I only receive one entry which is "?". Taking the focus off the record all of the shown values for employee change to the first record on the employee table (since that field is a global).
First, my difficulty to the condition value list. Even reading most of the previous posts on the subject I am stuck.
Second, am I better off creating with field within the Job_Dates table as a transfer field for each record to record the employee assignment?
Any assistance would be appreciated.