What I am trying to achieve: I have an inspection to be done, my user goes to the facility and selects the system they will be inspecting
Here is the table from which the above info is coming from
When selected, it opens a form
What I want is the info from the table for that one system that was selected to populate into the corresponding fields (Facility, System Type, Model/Serial, Facility ID, etc) this is where I am stuck.
Currently when the row is selected it just opens a blank form. The purpose of this is so they do not have to enter the lengthy info that we already have on file each time they do the inspection.
Here is a screenshot


