AnsweredAssumed Answered

Conditonal Value List w/ Portal and Unrelated Table

Question asked by t_e_x on Apr 19, 2016
Latest reply on Apr 20, 2016 by erolst

I am starting to believe I am attempting the impossible here, but here goes.  I have the following tables:

Screen Shot 2016-04-19 at 3.09.00 PM.pngScreen Shot 2016-04-19 at 3.09.56 PM.pngScreen Shot 2016-04-19 at 3.10.15 PM.png

 

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:

Screen Shot 2016-04-19 at 3.21.20 PM.png

to feed the layout:

Screen Shot 2016-04-19 at 3.23.30 PM.png

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.

 

Thank you,

 

Michael

Outcomes