(newbie)
I'm trying to create a Web Part to track progress against mandated training and surveys. The mandated training and surveys list has a training/survey name and a required due date.
The web part will display training/survey name (picked from a lookup drop down), the required due date, person's name (picked from a lookup drop down) and completion data (calendar grab date control).
The problem is that when an entry is selected from the drop down list of training/survey name, I also want the due date associated with that record to be used to populate the due date on the web part. I can't figure out how to link the two together through the UI. I'd rather avoid placing the training name and due date in the same field.
Example
training/survey list:
training_name due_date
Fire Safety 12/31/2020
Web Part
training_name due_date employee completed_date
Fire Safety 12/31/2020 Joe 10/31/2020