Thanks sachith,
I have used connection view, but now I need to filter based on roleid= "witness";
I am using below query just for retrieving for filtering what should be the condition, please provide me the query .
SELECT
new_incidentreport.new_Date,
new_incidentreport.new_name,
new_incidentreport.new_TrackingNumber,
new_incidentreport.new_Actionstaken,
new_incidentreport.new_DescriptionofInjuries,
new_incidentreport
.new_DescriptionofWeapons,
new_incidentreport.new_EmployeeSignature,
new_incidentreport.new_PlannedUseofForce,
new_incidentreport.new_Time,
new_incidentreport
.new_ToName,
new_incidentreport.new_TypeofIncidentName,
new_incidentreport.new_DetailedDescriptionofIncident,
Connection.Record2IdName
FROM
new_incidentreport CROSS
JOIN
Connection