How is location data populated in the Rating Form when it opens?
Add an action 'When Form Opened / Update Value' on the form, and use the query: SELECT Location, Name, 'Red' FROM dbo.R_LOCATION_INFORMATION WITH (NOLOCK).
Add an action 'When Form Opened / Update Value' on the form, and use the query: SELECT Location, Name, 'Red' FROM dbo.R_LOCATION_INFORMATION WITH (NOLOCK).