AnsweredAssumed Answered

Having one Portal update two tables?

Question asked by t_e_x on Mar 22, 2016
Latest reply on Mar 24, 2016 by BillisSaved

I am trying to create a layout in which the user can rapid input various designated dates associated with a job.  I have a global table to house the global variables to filter the records for the portal. 

Screen Shot 2016-03-22 at 10.39.41 AM.png

The portal is setup with the following fields based on Job_Dates_Quick:

     Job_Dates_Quick::_kf_JobID

     Job_Dates_Quick::Date

     Job_Dates_Quick::DateType

     _Global_QD_Jobs_Dates_Job_Emp::Emp_Initials

     _Global_QD_Jobs_Dates_Job_Customer::CustomerName (if verfication, no data entry)

 

The all of the field correctly display data that exists in the table.  However, I an unable to input Emp_Initals unless a value already exists for new records into Job_Dates_Quick.

 

How would I go about being able to input data in Emp_Initials?

 

I would appreciate any guidance.

 

Thank you,

 

Michael

Outcomes